Tag Archives: T-SQL
-
Turning ANSI_PADDING off, and why you shouldn’t
3June 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 -
Hiding tables in SSMS Object Explorer
Leave a commentApril 3, 2017 by Kenneth Fisher
Extended Properties Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had …
Continue reading -
Creating a list of random numbers
1March 22, 2017 by Kenneth Fisher
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly …
Continue reading -
The parts of an object’s name
Leave a commentMarch 20, 2017 by Kenneth Fisher
Any object within a database in SQL Server has what is called a four part name. Which rather implies four …
Continue reading -
Using GROUP BY instead of DISTINCT
6March 6, 2017 by Kenneth Fisher
Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers …
Continue reading
