Tag Archives: language sql
-
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 -
A script to list the DTS connection information for every package on the instance.
2October 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 -
Force only certain values to be unique
1October 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 -
Update to “The clustered index columns are in all of the non clustered indexes.”
5October 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 -
UNION vs UNION ALL
7October 16, 2014 by Kenneth Fisher
You might be wondering why I’m going into such a simple subject. Well the way I see it there are …
Continue reading -
You can’t use aggregate/windowing functions with CROSS APPLY
11October 6, 2014 by Kenneth Fisher
One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well …
Continue reading -
Changing configuration settings with sp_configure
5September 22, 2014 by Kenneth Fisher
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that …
Continue reading -
Triggers are not toys!
9September 17, 2014 by Kenneth Fisher
For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL …
Continue reading
SQL Studies 