Tag Archives: code language
-
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 -
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 -
What I know about batch files
25September 24, 2014 by Kenneth Fisher
For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how …
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 -
I SCHEMABOUND my scalar UDF and you won’t believe what happened next.
1September 15, 2014 by Kenneth Fisher
Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this …
Continue reading -
What are trace flags?
3September 11, 2014 by Kenneth Fisher
Trace flags are one of those things that I’ve heard about more and more over the last five or six …
Continue reading -
Two simple commands that can be a big help in performance tuning.
10September 2, 2014 by Kenneth Fisher
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are …
Continue reading
SQL Studies 