Monthly Archives: February 2014

  1. Impersonating a server level permission

    8

    February 26, 2014 by Kenneth Fisher

    Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s …
    Continue reading

  2. What’s the difference between a temp table and a table variable?

    2

    February 24, 2014 by Kenneth Fisher

    I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the …
    Continue reading

  3. Finally added a (t) to my (b)

    Leave a comment

    February 19, 2014 by Kenneth Fisher

    I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter. …
    Continue reading

  4. Getting a query plan

    2

    February 19, 2014 by Kenneth Fisher

    Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware …
    Continue reading

  5. DBA Myths: An index on a bit column will never be used.

    4

    February 17, 2014 by Kenneth Fisher

    Not true. (Or I guess probably wouldn’t be posting about it would I?) Probably the first thing I should point …
    Continue reading

  6. T-SQL Tuesday #51: Doubledown disaster

    3

    February 11, 2014 by Kenneth Fisher

    Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!. It’s always a gamble when buying …
    Continue reading

  7. Check your SQL Agent history settings before it’s too late!

    5

    February 10, 2014 by Kenneth Fisher

    A little while back I was doing some research into a failed job and ran into a slight problem. The …
    Continue reading

  8. Transactions: What commands aren’t allowed?

    Leave a comment

    February 5, 2014 by Kenneth Fisher

    Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put …
    Continue reading

  9. Transactions: Creating a single restore point across multiple databases.

    Leave a comment

    February 3, 2014 by Kenneth Fisher

    This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple …
    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