Tag Archives: T-SQL

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

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

    Leave a comment

    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

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

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

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

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

  7. Queries with optional parameters

    10

    February 27, 2017 by Kenneth Fisher

    These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
    Continue reading

  8. What’s in my backup file?

    Leave a comment

    February 22, 2017 by Kenneth Fisher

    Restoring a backup file is pretty easy right? Ok, but what if more than one database backup is stored in …
    Continue reading

  9. Deadlock priority

    5

    February 8, 2017 by Kenneth Fisher

    Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who …
    Continue reading

  10. Lead Blocker

    7

    January 18, 2017 by Kenneth Fisher

    Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and …
    Continue reading

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

Join 1,628 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013