I am really amazed that anyone even knows the DBCC(LOG) command anymore. It was common in the early life of SQL Server, but I haven't seen mention of it since...

I voted 5 star. I can't wait to examine it in detail.

I thought the time involved was very excessive for such a small update as well, and decided there had to be other factors involved to slow it down. I was...

By eliminate the nulls, I meant something more like IsNull([field], "alternateValue")

don't remove records, just replace null values.

In cases where I need to guarantee the availability of a linked server, I query a system object on the linked server, and check for a known return. If it's...

I just thought about it some more, and if you don't like the DTS route, just use recordset objects, eliminate the nulls in the query results, and use an excell...

VB can call DTS packages. And for the nulls, eliminate them in your query returning the results. A parameter passed into your DTS package could supply the code changes for...

Set up a profile trace that includes index ID, monitor it for index id's of 0, which are table scans. This also gives you the exact statement causing the table...

This may seem simplistic, but if you can do it in QA, why can't you just throw that into a DTS and write it to excel (If you need a...

Most of mine average between 25 GB and 280 GB, the exceptions are over a terrabyte each and are datawarehouses.

I've seen the text truncation deal. In the case I saw it, the server's settings for ansi_nulls was set one way and the QA's settings had been modified to treat...

You could break it up into batches.

Something like setting your record count to some number, say 5 or 10 thousand, and looping until you get them all. Maybe even set...

Yall clue me in here. Other than for space reasons (as I believe you should have adaquate space to start with as one of the things I hear most is...

Oh, come on Antares686, you've heard of scope creep, well this is thread creep.

LMAO...

I implemented your code on on of my systems and followed your article to produce the same graphs that you created, and it proved to be a breakthrough in communictaion...