Tag Archives: language sql
-
Writing Dynamic SQL (A how to)
6July 1, 2013 by Kenneth Fisher
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions …
Continue reading -
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 -
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 -
Backup a password, change it, then restore it.
3May 30, 2013 by Kenneth Fisher
A couple of months ago I talked about moving a login from one server to another without the password. The …
Continue reading -
Using CROSS APPLY to calculate an aggregate across a single row.
2May 28, 2013 by Kenneth Fisher
I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last …
Continue reading
SQL Studies 