Monthly Archives: June 2013
-
Using OUTPUT to back up a change
2June 26, 2013 by Kenneth Fisher
How will you back out if your change doesn’t work?! Always take a backup! There should always be a back …
Continue reading -
Metadata Functions (OBJECT_NAME for example)
Leave a commentJune 24, 2013 by Kenneth Fisher
What is a metadata function? According to BOL a metadata function is one that returns data about the database or …
Continue reading -
Disaster Recovery’s big brother Operational Recovery
15June 20, 2013 by Kenneth Fisher
I’m going to get slammed for the title by someone but I stand by it. First some definitions. Disaster Recovery …
Continue reading -
ORDER BY the numbers
17June 17, 2013 by Kenneth Fisher
Have you ever needed to order by a calculated column? You might have written it something like this: Did you …
Continue reading -
Best practice recommendations for writing Dynamic SQL
16June 12, 2013 by Kenneth Fisher
Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over …
Continue reading -
Using the OVER clause
2June 10, 2013 by Kenneth Fisher
Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has …
Continue reading -
Easy way to generate a restore script.
Leave a commentJune 5, 2013 by Kenneth Fisher
Easy way to generate a restore script. I was asked today if I had a canned restore script handy. I …
Continue reading -
Pattern searches beyond ‘%string%’.
4June 3, 2013 by Kenneth Fisher
I was asked today to take a table with a social security column and put all 0s if the column …
Continue reading