Category Archives: T-SQL
-
What is a CTE
Leave a commentApril 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.
9March 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?
4March 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.
Leave a commentMarch 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?
Leave a commentMarch 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
14February 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 -
Tales of a DBA fed up with NOLOCK. Part 1
36February 16, 2015 by Kenneth Fisher
Nov 12, 2014 Dear Diary, They asked for help again. Every now and again everything slows down and they see …
Continue reading -
Dealing with layered function calls
5February 5, 2015 by Kenneth Fisher
T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are …
Continue reading -
SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC
1January 26, 2015 by Kenneth Fisher
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
Continue reading
