Multiset difference removes matching occurrences while keeping any extra copies from the left input. I assign occurrence numbers before pairing rows. A value’s presence on the right should not automatically remove every left copy.
SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
How to change connection properties in SSMS as you connect, like using named pipes instead of TCP/IP, as I do for one of our servers. Screenshots show each step.
Why You Should Name Default Constraints
Name default constraints so deployments can find them reliably, and replace system-generated names through a reviewed migration.
SQL SERVER – 2005 – Different Types of Cache Objects
A quick look at the different types of cache objects SQL Server 2005 keeps in the procedure cache, from a troubleshooting book I reviewed.
LEN Versus DATALENGTH: Trailing Spaces and Unicode Bytes
LEN versus DATALENGTH answers different length questions. Use explicit text types to check trailing spaces, Unicode bytes, empty values and NULL.
THROW or RAISERROR
THROW or RAISERROR changes how SQL Server handles severity, formatting, and XACT_ABORT; choose the right pattern for new procedures.
SQL SERVER – Order of Result Set of SELECT Statement on Clustered Indexed Table When ORDER BY is Not Used
A Clustered Indexed Table still needs ORDER BY to promise result order. I declare the order the reader or application requires.