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 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE
SQL Server 2005 has four ranking functions: ROW_NUMBER, RANK, DENSE_RANK and NTILE. I explain what each returns and show a sample example of all four.
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 – Executing Remote Stored Procedure – Calling Stored Procedure on Linked Server
Two ways to call a remote stored procedure on a linked server: a four part name with EXEC, or the OPENQUERY distributed query function.
SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example
Open SSMS from command prompt with the sqlwb command. I show its syntax and the switches I use, like -E and -nosplash, to start Management Studio.
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.