Tag Archives: sql statements
-
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 -
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 -
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 -
More than sp_help
6August 14, 2014 by Kenneth Fisher
If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
Continue reading -
What is ANSI_NULLS and why will I be glad when it finally goes away?
13July 28, 2014 by Kenneth Fisher
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and …
Continue reading -
Why am I getting a primary/unique key violation?
3July 23, 2014 by Kenneth Fisher
This may seem like a question with a simple answer but there is a bit more to it than you …
Continue reading -
15 years of experience with Identity columns
51June 4, 2014 by Kenneth Fisher
An identity column is an auto incrementing column An identity column is typically used as a primary key A primary …
Continue reading -
What is the difference between Money and Decimal(19,4)
8June 2, 2014 by Kenneth Fisher
One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4). …
Continue reading -
Escaping from a runaway Logon trigger
11May 19, 2014 by Kenneth Fisher
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
Continue reading
SQL Studies 