SQL 2012 has Launched

LAUNCH
If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched.  With it,...

SQL 2012 has Launched

LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched.  With it, some really cool features are now available to...

Seldom Used Indexes

On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then...

Seldom Used Indexes

On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then possibly a manager or client.  Usually this comes up...

Another Interesting Sort

In October of 2011, I shared an example of a peculiar set of sort requirements.  Today, I am going to...

Another Interesting Sort

Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:

Creative Database Naming January 2, 2020...

Agent Jobs Using SSIS

This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those...

Agent Jobs Using SSIS

This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those cases where you are consulting or you have taken...

Table Size and Missing FK Indexes

I am bringing an oldie back with another twist.  I recently ran into the need to correlate information between a...

Table Size and Missing FK Indexes

I am bringing an oldie back with another twist.  I recently ran into the need to correlate information between a couple of different queries that I like to use....