Monthly Archives: November 2014

  1. Who’s on call

    Leave a comment

    November 26, 2014 by Kenneth Fisher

    Originally posted on SQL Studies:
    Every morning we have a daily meeting and my manager asks who’s on call. And every…

  2. Putting sp_ at the beginning of your stored procedure.


    November 24, 2014 by Kenneth Fisher

    Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So …
    Continue reading

  3. You don’t really need ORDER BY do you?


    November 19, 2014 by Kenneth Fisher

    You see dozens of blog posts and articles about how the order of a result set is not guaranteed without …
    Continue reading

  4. Using T-SQL to populate a Central Management Server


    November 17, 2014 by Kenneth Fisher

    We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the …
    Continue reading

  5. Adding a column to the primary key.


    November 13, 2014 by Kenneth Fisher

    Every now and again you realize that the primary key for a table does not uniquely describe a row. Not …
    Continue reading

  6. TSQL Tuesday #60: Something New Learned – What permissions does <username> have?


    November 11, 2014 by Kenneth Fisher

    What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to …
    Continue reading

  7. How to remove additional (unwanted) log files


    November 5, 2014 by Kenneth Fisher

    Using multiple data files is a common best practice for a number of reasons, but multiple log files? Typically a …
    Continue reading

  8. My DTS Package won’t load with the error “here were errors loading package”

    Leave a comment

    November 3, 2014 by Kenneth Fisher

    You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error: …
    Continue reading

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013