Category Archives: T-SQL
-
Uniquifier is a rather unique word isn’t it?
3September 18, 2017 by Kenneth Fisher
tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique. Uniquifier is a rather funny …
Continue reading -
Help! My query is too fast!
1September 14, 2017 by Kenneth Fisher
Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of …
Continue reading -
There EXISTS a place where SELECT 1/0 doesn’t return an error.
3September 7, 2017 by Kenneth Fisher
Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical …
Continue reading -
Create an empty table from a SELECT statement but without the IDENTITY.
3August 28, 2017 by Kenneth Fisher
A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like …
Continue reading -
SQL Homework – August 2017 – Create a table
4August 2, 2017 by Kenneth Fisher
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month …
Continue reading -
Save and save often
2July 11, 2017 by Kenneth Fisher
It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday! …
Continue reading -
SQL Crossword : T-SQL Keywords : June 2017
2June 28, 2017 by Kenneth Fisher
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked …
Continue reading -
Temp table quiz
10June 26, 2017 by Kenneth Fisher
Brent Ozar (b/t) posted a pop quiz on twitter earlier today. Go ahead and give it a shot .. I’ll …
Continue reading -
Adding Identity to an existing column
1June 19, 2017 by Kenneth Fisher
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He …
Continue reading -
Turning ANSI_PADDING off, and why you shouldn’t
4June 15, 2017 by Kenneth Fisher
I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
Continue reading
