Category Archives: T-SQL
-
Blocking and deadlocking on purpose
3July 1, 2015 by Kenneth Fisher
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling …
Continue reading -
Which user function do I use?
3June 24, 2015 by Kenneth Fisher
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you …
Continue reading -
Adding, altering or removing multiple columns from a table
2April 16, 2015 by Kenneth Fisher
I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing …
Continue reading -
What is a CTE
3April 6, 2015 by Kenneth Fisher
CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade. …
Continue reading -
Clean out all bad characters from a string.
10March 25, 2015 by Kenneth Fisher
I have a customer who is having a problem with a load. He is getting a fair number of bad …
Continue reading -
Why not NOLOCK?
10March 18, 2015 by Kenneth Fisher
Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
Continue reading -
There are #temp tables and then there are ##temp tables.
1March 16, 2015 by Kenneth Fisher
Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly …
Continue reading -
Who’s using that database?
1March 9, 2015 by Kenneth Fisher
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
Continue reading -
Test your UPDATEs and DELETEs before you run them
15February 18, 2015 by Kenneth Fisher
This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you …
Continue reading
SQL Studies 