Category Archives: T-SQL
-
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 -
T-SQL FizzBuzz
15May 17, 2017 by Kenneth Fisher
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old …
Continue reading -
Dynamic SQL and the joys of QUOTENAME
5May 11, 2017 by Kenneth Fisher
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even …
Continue reading -
Partitioning on a nullable column
3May 3, 2017 by Kenneth Fisher
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add …
Continue reading -
No space queries
2April 13, 2017 by Kenneth Fisher
You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The …
Continue reading -
How do I change the increment of an identity column?
2April 5, 2017 by Kenneth Fisher
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. …
Continue reading
