Two simple commands that can be a big help in performance tuning.

The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are...

Generating a restore script

In order to speed up our backups on a large database our team decided to stripe the backup files. In...

The amazing never shrinking heap

This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However...

Two years!

Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the...

More than sp_help

If you have worked with SQL Server for very long you have probably run across the extremely useful system function...

Deny vs Revoke

Quick quiz. Which of these two commands is the opposite of GRANT?
DENYREVOKE 

Well lets start with some definitions
GRANT – Grants permissions on...

T-SQL Tuesday #57: SQL Family

This month’s T-SQL Tuesday topic is SQL Family and is brought to us by Jeffrey Verheul (b/t). It’s an amazing...

The clustered index columns are in all of the non clustered indexes.

Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes...

SchemaBinding – What & Why

What
When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables...

What is ANSI_NULLS and why will I be glad when it finally goes away?

Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and...