Category Archives: SQLServerPedia Syndication
-
TSQL Tuesday #61: Giving Back, you gain more than you give.
Leave a commentDecember 9, 2014 by Kenneth Fisher
Almost four months ago I posted my goals for the next year in my two year anniversary post. I pretty …
Continue reading -
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
SQL Studies 