Tag Archives: T-SQL

  1. Queries with optional parameters

    4

    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

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

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

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

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

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

  7. sp_helptext vs object_definition()

    3

    December 21, 2016 by Kenneth Fisher

    I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I …
    Continue reading

  8. Using OUTPUT with a field list.

    2

    November 30, 2016 by Kenneth Fisher

    I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a …
    Continue reading

  9. It greatly pleases me to announce, HAL0003!

    24

    November 23, 2016 by Kenneth Fisher

    I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal …
    Continue reading

  10. Reload a table quickly.

    4

    November 21, 2016 by Kenneth Fisher

    Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload. …
    Continue reading

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

Join 1,608 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013