Tag Archives: T-SQL
-
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 -
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 -
SchemaBinding – What & Why
29August 6, 2014 by Kenneth Fisher
What When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying …
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
SQL Studies 