-
Triggers are not toys!
9September 17, 2014 by Kenneth Fisher
For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL …
Continue reading -
I SCHEMABOUND my scalar UDF and you won’t believe what happened next.
1September 15, 2014 by Kenneth Fisher
Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this …
Continue reading -
What are trace flags?
3September 11, 2014 by Kenneth Fisher
Trace flags are one of those things that I’ve heard about more and more over the last five or six …
Continue reading -
T-SQL Tuesday #58: Passwords
2September 9, 2014 by Kenneth Fisher
It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host …
Continue reading -
Pausing an MSSQL Instance
10September 4, 2014 by Kenneth Fisher
I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop …
Continue reading -
Two simple commands that can be a big help in performance tuning.
10September 2, 2014 by Kenneth Fisher
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are …
Continue reading -
Finding a job!
5August 27, 2014 by Kenneth Fisher
I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years …
Continue reading -
The amazing never shrinking heap
Leave a commentAugust 25, 2014 by Kenneth Fisher
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However …
Continue reading -
Two years!
7August 20, 2014 by Kenneth Fisher
Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the …
Continue reading -
Generating a restore script
9August 18, 2014 by Kenneth Fisher
In order to speed up our backups on a large database our team decided to stripe the backup files. In …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 