Tag Archives: T-SQL

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

    3

    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

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

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

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

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

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

  7. Hiding tables in SSMS Object Explorer

    Leave a comment

    April 3, 2017 by Kenneth Fisher

    Extended Properties Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had …
    Continue reading

  8. Creating a list of random numbers

    1

    March 22, 2017 by Kenneth Fisher

    I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly …
    Continue reading

  9. The parts of an object’s name

    Leave a comment

    March 20, 2017 by Kenneth Fisher

    Any object within a database in SQL Server has what is called a four part name. Which rather implies four …
    Continue reading

  10. Using GROUP BY instead of DISTINCT

    6

    March 6, 2017 by Kenneth Fisher

    Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers …
    Continue reading

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

Join 1,653 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013