Hey Paul, If you won't beat your own drum I will

GO HERE !!!!

http://www.microsoft.com/emea/teched2008/itpro/tv/default.aspx?vid=78.

LEARN

Enjoy!

I did and have discovered the Power of DBCC page and Checkdb, and...

Data modification statements typically request both shared locks and exclusive locks !!

from MSDN

When lock escalation occurs, the lock selected for the heap or index is strong enough to meet...

The more I read on this thread the more worried I become... do you actually believe this ...?

RUNNING OUT OF DISK SPACE WILL NOT SEND YOUR DATABASES SUSPECT.

Come on...

Hey this is NOT a good practice "DBCC FREEPROCCACHE" frees ALL the cache inforamtion for the SERVER. Do this on a OLTP Database and LTUR (Leave town and...

If you are really fighting for microseconds

If Exists ( Select Null from bigtable Where ...) also is a good test with minimal Overhead instead of Select 1

Begin

.... fancy code

End

But...

Go here, look listen and learn.

http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-80-minute-video-of-Corruption-Survival-Techniques-presentation.aspx

I can't say this loud enough

DONT GO ANYWHERE WITHOUT DOING SO. IT IS THE BEST 80 MINUTES YOU"LL EVER...

@ Paul R, Thanks for your input. Personally, this article should never have got off the Editors desktop. It is akin to answering "How do I get...

Sorry Guys and Gals but I couldn't stay quiet over this.

1.If you move Data files when in 'off line' mode it should have been communicated to your stakeholders that...

This is an old thread but just in case anyone is still interested I think I solved it.

The issue might be caused by a combination of things and one of...

This is an old thread but just in case anyone is still interested I think I solved it.

The issue might be caused by a combination of things and one of...

This is an old thread but just in case anyone is still interested I think I solved it.

The issue might be caused by a combination of things and one of...

RBarryYoung (5/14/2009)

---

Malcolm Daughtree (5/14/2009)

---

... There is a technical reason why Data and log files should be on a separate physical hard drives. And its not cost or performance...

John,

Thanks for the info, yes that helped. It is a balancing act between Pages used, Physical fargmnetation of the Datafile, Pad Index / fill factors and the like....

Just one parting comment to a topic that seems to have gone to the dogs... There is a technical reason why Data and log files should be on a separate...

I agree in principal but, The error 'Insufficient resources' is exactly what the situation is if the job contained a DBCC CheckDB command.

Windows 2003 Error: The operating system returned...