After doing some research, I'll answer my own question.

“It has been always challenging for database administrators to identity indexes that are missing on a table. In SQL Server 2005, Microsoft...

You know your situation better than I do but could it be possible that there were budget issues that your supervisor was having to deal with and maybe if he...

Jeffrey,

Thanks. I'll arrange for SQL Server to receive the updates it needs.

LC

Wilfred and Jason,

Thanks to both of you for taking the time to implement and publish your queries.

I have an immediate use for them at work.

LC

Thanks.

LC

Wilfred,

What is the purpose of this elaborate query?

(NOTE: I have commented out the ALTER INDEX (DISABLE) statement until I get an explanation of what the query is supposed to...

Thanks, Grant.

LC

I just found it in Books Online.

This query will provide them: "SELECT * FROM sys.dm_os_performance_counters".

LC

Gentlemen,

Thank you for your advice. It worked.

LC

The rollback completed and left me with almost no disk free space, about 3.5 MB on a 136 GB drive.

I performed a SHRINK DATABASE on the database which now...

Our server is a 64 bit machine.

I've only recently begun to track the actual size of the plan cache so I have no prior reference points for comparison.

The...

COL (chuckle out loud). Our programmers actually are very clever but they specialize in .NET and I specialize in SQL and SQL Server, so I'm constantly educating them on the...

I hope this post is useful to others.

I've discovered the cause of our SQL Plan Cache problem: Cache Bloat.

Our programmers are pretty clever and to solve some problems associated with...

Thanks for the advice.

"Auto-update statistics" is enabled on all of our databases but it is not quite enough.

Our databases have a very high level of inbound traffic. Looking at...

At the risk of commandeering your post, I have a similar but somewhat different observation (issue?) regarding TempDB.

I take weekly screenshots of the Disk Usage Report for all databases...