Monthly Archives: December 2013

  1. The 12 days after release


    December 24, 2013 by Kenneth Fisher

    On the first day after release my developer gave to me a performance problem on a crucial query   On …
    Continue reading

  2. SSMS Shortcuts and more

    Leave a comment

    December 23, 2013 by Kenneth Fisher

    I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs. …
    Continue reading

  3. Transactions: Rolling back part of a transaction.


    December 19, 2013 by Kenneth Fisher

    In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way …
    Continue reading

  4. Transactions: Rolling back a nested transaction


    December 17, 2013 by Kenneth Fisher

    Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID). …
    Continue reading

  5. T-SQL Tuesday #49: Wait for it


    December 10, 2013 by Kenneth Fisher

    It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits. …
    Continue reading

  6. Undocumented functionality in FORMATMESSAGE


    December 9, 2013 by Kenneth Fisher

    I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which …
    Continue reading

  7. Insert into a table using only default values


    December 4, 2013 by Kenneth Fisher

    A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value …
    Continue reading

  8. Why do DBAs like to say “It Depends” so much?


    December 2, 2013 by Kenneth Fisher

    Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice …
    Continue reading

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013