Category Archives: Microsoft SQL Server
-
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 -
Using CROSS APPLY instead of a calculated variable
3May 22, 2013 by Kenneth Fisher
Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working …
Continue reading -
The many uses of CROSS APPLY
4May 20, 2013 by Kenneth Fisher
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the …
Continue reading -
CREATE SCHEMA can do what?!?!?
4May 15, 2013 by Kenneth Fisher
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t …
Continue reading -
Dragging a name from the object explorer to a query window
8May 13, 2013 by Kenneth Fisher
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that …
Continue reading -
Free SQL Books
4May 8, 2013 by Kenneth Fisher
I was looking for a way to put BOL on my Kindle when I found a few good links I …
Continue reading
SQL Studies 