IF things are well designed. As a Support Person or DBA, you often have little or no control over the coding practices of the application developers. If they want to...

Do you have to handle multiple date time columns in the tables you are monitoring??

Don't forget to consider multiple instances. If you have Applications A,B,C, and D on one instance of SQL Server, and maybe Application A bloats up the mem to leave cache...

Please remember we are not playing Jeopardy here, where you give the solution and we guess what the problem is.

If you want the proper help you will have to...

If you are only talking about your electric bill, then just use a spreadsheet.

I really do not understand what you are asking.

How many records do you anticipate having? 10's or Millions?

How will you be using the data?

Do you have any requirements that you can pass along?

Your needs will dictate the solution....

This is good info, but I don't see how it matches the article title. Would anyone mind "join"-ing the dots for me?

Before you go throwing hardware at it find out where your performance bottleneck is. Use the builtin performance counters to try and isolate the component that is not performing as...

Can you post schema, sample data, and desired output?

Thanks Peter, I'll give it a try.

Does anyone know if is there any way to do it from inside a QA or SSMS session? (opendatasource?)

Whats the STOP hex code? (0x0000ABCDE). Those are the most easily translatable parts of the dump. This sites should help you figure out the root of the problem.

http://www.aumha.org/win5/kbestop.php

-or-

Google...

You should filter out spids less than 52 (<=51), the system processes wont need to be looked at, and order that list!

I am guessing the minute count is high because...

Can you give us more details? I'm not 100% on what you are looking to accomplish.

You may want to explore diskkeeper or a similar product. It will allow you to schedule defrags or run when the CPU is idle.

Either of those will allow you...

truncate table is faster.