Tag Archives: microsoft sql server
-
INSERT INTO SELECT vs SELECT INTO
5December 3, 2014 by Kenneth Fisher
INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and …
Continue reading -
Using a date or int column as the clustered index.
13December 1, 2014 by Kenneth Fisher
The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on …
Continue reading -
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 -
Playing with the log – Before the first full backup
1October 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
SQL Studies 