Monthly Archives: August 2014
-
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 -
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 -
T-SQL Tuesday #57: SQL Family
1August 12, 2014 by Kenneth Fisher
This month’s T-SQL Tuesday topic is SQL Family and is brought to us by Jeffrey Verheul (b/t). It’s an amazing …
Continue reading -
SchemaBinding – What & Why
28August 6, 2014 by Kenneth Fisher
What When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying …
Continue reading
SQL Studies 