Tag Archives: microsoft sql server
-
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 -
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 -
More than sp_help
6August 14, 2014 by Kenneth Fisher
If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
Continue reading -
The clustered index columns are in all of the non clustered indexes.
13July 30, 2014 by Kenneth Fisher
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes …
Continue reading
SQL Studies 