Category Archives: Microsoft SQL Server

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

    1

    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

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

    Leave a comment

    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

  3. Adding a column to the primary key.

    2

    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

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

    2

    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

  5. How to remove additional (unwanted) log files

    Leave a comment

    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

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

  7. Playing with the log – Before the first full backup

    Leave a comment

    October 29, 2014 by Kenneth Fisher

    The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the …
    Continue reading

  8. A script to list the DTS connection information for every package on the instance.

    Leave a comment

    October 27, 2014 by Kenneth Fisher

    For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the …
    Continue reading

  9. Force only certain values to be unique

    1

    October 22, 2014 by Kenneth Fisher

    I thought of something rather interesting the other day while answering a question asking for help with some table structures. …
    Continue reading

  10. Update to “The clustered index columns are in all of the non clustered indexes.”

    2

    October 20, 2014 by Kenneth Fisher

    I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 475 other followers