Gail's excellent article caused me to re-examine a slow running query. I changed the WHERE clause slightly and examined the resulting execution plan. I implemented the changes and got a...

We are still predominately SQL 2K. We hope to migrate to 2005 early in the next decade. :sick:

On my SQL 2000 system the SP_SpaceUsed method was considerably faster than the select Count(*) method. The system was not idle at the time, but the numbers are certainly directional.

I...

I use a method similar to the one described in the article. The procedure runs each night during a quiet time on the server. It writes the information to a...

Thanks for the response. I'll give UPDATE STATISTICS a try next time I encounter the issue since it would probably be faster than DBREINDEX.

Do you recall if DBCC INDEXDEFRAG also...

I use a similar technique on a server I work with. The primary benefit of this information is to be able to talk to business owners in a way they...

So the QotD answer was wrong but I learned something anyway -- I had forgotten about the rounding issue.

It reminded me of an Advanced Electromagnetic Fields class I took in...

The solution to this particular problem was to compare the date/time that the stored procedure wrote to the heartbeat table showing when the process started vs. the date/time of the...

Yes, it runs on a secondary desktop system in my cubicle. I'd like the process to run 24x7x365.

When it fails, meaning...

It depends on your people skills and your enjoyment of working with "people" issues rather than strictly computer issues. This might be a good opportunity...

Some solutions and best practices apply irrespective of the version. What about a structure where the version is broken out only if it is significant. For example:

...

I work in an environment that fits the scenario that Phil describes.

I receive about one million rows...