Good timing on the article. Our company just completed our yearly DR practice test. It's not an exhaustive test, but we take some of the more critical systems...

Great article David. I was going to ask the same question about proc cache limits, but I have heard about the "stolen pages" concept too. So, it might...

One more minor add-on:

I wrote a similar stored procedure that allows me to pass in a stored procedure name and parameters and it would write the results to a table....

Paul, great post and even better timing. We had an issue with paging on a larger table just last week and I've spent a fair amount of time trying...

Thanks for the quick reply. I should have included that in my post. We entered the -T1448 in the startup parameters and restarted the box. Actually I...

Question about this flag, it says its available as a hotfix for Sql Server 2005 SP2, but if I have SP3, shouldn't this fix be included? I've applied the...

If there are many foreign key relationships and the tables end up being deleted, beware. Deleting is a logged operation and your log file will go through the roof...

I agree that there are better solutions, this script helps you when you have a legacy system that you didn't design. We all have those.

Btw, be careful...

Thanks for the article. I had to do a similar thing for our development and test environment. We have two databases in production that have views that point...

@PaulWhite said: Absoutely - and I was going to include a quote from BOL to make the point that system views are preferred over INFORMATION_SCHEMA...but I didn't want to pile...

Thanks for the article, I use this "feature" quite a bit. One of mine is similar to yours, I have a script that creates insert statements using column names...