Monthly Archives: September 2017

  1. SQL Puzzle – Prime Numbers

    6

    September 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

  2. Saving and restoring session options settings

    4

    September 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

  3. Do what I say, not what I do

    Leave a comment

    September 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

  4. Uniquifier is a rather unique word isn’t it?

    8

    September 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

  5. Help! My query is too fast!

    1

    September 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

  6. Turn on/off Azure VMs with Powershell

    1

    September 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

  7. There EXISTS a place where SELECT 1/0 doesn’t return an error.

    3

    September 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

  8. SQL Homework – September 2017 – Create a home lab

    Leave a comment

    September 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,148 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013