Determining Cardinality and Optionality
Oct 4, 2013 · How do I determine the cardinality and optionality of a table relationship? Please see diagram and rule for more information.
Limiting the number of concurrent sessions per user
Feb 12, 2019 · As following to my local security policy, I have to establish the limit appropriate to the type of user account accessing the SQL Server instance on SQL Server 2014 Enterprise.
Adding additional data files to Tempdb? is it an online operation?
Dec 9, 2014 · I have tested and found that it is an online operation (It did not have any effect on the DB) but was little curious to do the same thing on a production server.
MySql not working with async methods in a foreach loop "This ...
Oct 7, 2021 · And your reasoning to move to MySQL from MS SQL Server is what? The link is self-explanatory the one you posted about 'see'.
TSQL Script to restore the latest full backup from shared path
Sep 19, 2019 · I need a Script to restore the latest full backup from shared network path.
SSRS configuration manager - social.msdn.microsoft.com
Jun 28, 2013 · Can anyone point me to a simple explanation of using the SSRS configuration manager to manage different servers for shared data sources and project properties per …
stored procedure for rebuild indexes - social.msdn.microsoft.com
Oct 11, 2012 · USE [databasename] GO StoredProcedure [dbo]. [sp_RebuildIndexes] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo]. …
Update Statement With OpenQuery - social.msdn.microsoft.com
Nov 25, 2016 · Answers 1 Sign in to vote ; with cte As (Select salesname, totalsales FROM OPENQUERY ( [sqlcl02,2433], 'Select a.salesname SalesName ,b.salesTotal TotalSales from …
How to write calculations for CurrentWeek,CurrentMonth, Current …
Feb 3, 2016 · I need to write the MDX Expressions to calculate the [Incident Count] for CurrentWeek,CurrentMonth, Current Quarter.
Insert Into Where Not Exists - social.msdn.microsoft.com
Jan 28, 2016 · I have two tables that have same data structure. I need to insert into #rr what is in #bb that does not exist. Here is sample DDL - I think Merge Could do it, but not 100% sure ....