Tags » Microsoft SQL Server

Uniquifier is a rather unique word isn't it?

tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique.

Uniquifier is a rather funny name, and yet it’s very descriptive. 923 more words

SQLServerPedia Syndication

Find Tables That Have Special Features Enabled

Find out if any of tables in your database have special features enabled using the queries below.  These features need to be understood and carefully managed. 189 more words

SQL Server

Help! My query is too fast!

Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of a batch. For example, if I’m running a big delete I might create a loop and delete in batches. 197 more words

SQLServerPedia Syndication

There EXISTS a place where SELECT 1/0 doesn't return an error.

Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical joins (Q7) 421 more words

SQLServerPedia Syndication

SQL Homework - September 2017 - Create a home lab

As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something important at the start. It’s pointless to ask someone… 195 more words

SQLServerPedia Syndication