Monthly Archives: November 2014
-
Who’s on call
Leave a commentNovember 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… -
Putting sp_ at the beginning of your stored procedure.
1November 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 -
You don’t really need ORDER BY do you?
8November 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 -
Using T-SQL to populate a Central Management Server
6November 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 -
Adding a column to the primary key.
13November 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 -
How to remove additional (unwanted) log files
4November 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 -
My DTS Package won’t load with the error “here were errors loading package”
Leave a commentNovember 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