While looking at the Dynamic Management Views for missing indexes on the  Microsoft site I came across the comment on the SQL 2012 version. ...

Received a request for a list of our tables and how many records each table had in it.  In a situation like this you would want to avoid u...

It seems I've lost the ability to retain even the basic SQL information that I've learned over the years.  For the life of me I coul...

Well, it seems the DBA's frowned upon my access rights and quietly killed them.  My previous post regarding finding the available space ...

This code snippet allows you to check whether a temp table current exists.  If so, drop it.  I use this quite frequently when testing code t...

Yesterday I attempted to add a new index to my development database and it returned an error stating that the file group didn't have eno...

We are in the process of upgrading our SQL Servers to 2008.  While this is going on we still need to maintain and release code to the 2005 b...

My coworker and I are in the process of converting a bunch of 2005 SSIS Packages to 2008 SSIS. These packages are stored in the msdb datab...

So, today we've been tasked with a problem with slowness in the Query editor for one of our users. She uses the "Design Query in ...

We are in the process of refining some of our data types.  As part of this, we needed to know the space usage and row count of each table i...