Monthly Archives: May 2017
-
SQL Crossword
7May 31, 2017 by Kenneth Fisher
I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know …
Continue reading -
Running multiple queries at the same time.
8May 24, 2017 by Kenneth Fisher
I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at …
Continue reading -
What’s in a partition?
Leave a commentMay 22, 2017 by Kenneth Fisher
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit …
Continue reading -
T-SQL FizzBuzz
17May 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 -
Why shouldn’t I shrink my database log file?
10May 15, 2017 by Kenneth Fisher
TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
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 -
Continuous Integration
Leave a commentMay 9, 2017 by Kenneth Fisher
It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us …
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
SQL Studies 