Category Archives: T-SQL

  1. sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

    Leave a comment

    March 27, 2017 by Kenneth Fisher

    It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, …
    Continue reading

  2. Creating a list of random numbers

    Leave a comment

    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

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

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

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

  6. Deadlock on ALTER DATABASE

    3

    February 16, 2017 by Kenneth Fisher

    I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you …
    Continue reading

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

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

  9. Connect suggestion to add included columns to sp_helpindex

    Leave a comment

    January 10, 2017 by Kenneth Fisher

    I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the …
    Continue reading

  10. sp_refreshsqlmodule_internal – The user does not have permission to perform this action.

    Leave a comment

    December 28, 2016 by Kenneth Fisher

    Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found …
    Continue reading

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

Join 1,615 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013