Monthly Archives: September 2017
-
SQL Puzzle – Prime Numbers
9September 27, 2017 by Kenneth Fisher
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word …
Continue reading -
Saving and restoring session options settings
4September 25, 2017 by Kenneth Fisher
There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations. …
Continue reading -
Do what I say, not what I do
Leave a commentSeptember 20, 2017 by Kenneth Fisher
I told you not to use NOLOCK even though I use it sometimes. I told you not to shrink databases, …
Continue reading -
Uniquifier is a rather unique word isn’t it?
8September 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 -
Turn on/off Azure VMs with Powershell
1September 12, 2017 by Kenneth Fisher
T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked …
Continue reading -
There EXISTS a place where SELECT 1/0 doesn’t return an error.
4September 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 -
SQL Homework – September 2017 – Create a home lab
3September 5, 2017 by Kenneth Fisher
As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something …
Continue reading
SQL Studies 