Category Archives: T-SQL

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

    3

    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

  2. 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

  3. 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

  4. Create an empty table from a SELECT statement but without the IDENTITY.

    3

    August 28, 2017 by Kenneth Fisher

    A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like …
    Continue reading

  5. SQL Homework – August 2017 – Create a table

    4

    August 2, 2017 by Kenneth Fisher

    If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month …
    Continue reading

  6. Save and save often

    2

    July 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

  7. SQL Crossword : T-SQL Keywords : June 2017

    2

    June 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

  8. Temp table quiz

    10

    June 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

  9. Adding Identity to an existing column

    1

    June 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

  10. Turning ANSI_PADDING off, and why you shouldn’t

    4

    June 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

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

Join 1,682 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013