Category Archives: T-SQL

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

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

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

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

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

  6. T-SQL FizzBuzz

    15

    May 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

  7. Dynamic SQL and the joys of QUOTENAME

    5

    May 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

  8. Partitioning on a nullable column

    3

    May 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

  9. No space queries

    2

    April 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

  10. How do I change the increment of an identity column?

    2

    April 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

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

Join 1,664 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013