Howard.Veazey (5/24/2010)

---

FROM

...

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/

Please run the following on both servers and post the full and complete results.

SELECT @@version

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

And you've tested and measured...

Doesn't really sound like a job for a trigger. A couple of computed columns should work very well here. Check Books Online for details of computed columns. Maybe start here...

Yes. I would suggest that you set max memory no higher than 6GB, that's if the server is dedicated to SQL (nothing else on it). If there are other apps/services...

If you are running 64-bit SQL, you must set the max memory. SQL is a memory hog and it will happily use all available memory and ask for more.

What's the...

What's the exact version of SQL that you are running? There were bugs with the page usage metadata right up to SP3 iirc

Please don't crosspost. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic926640-146-1.aspx

Please don't type in all caps. It's the online equivalent of shouting at us. There's not need to use bold, caps and large fonts, they're not going to get your...

Please don't crosspost. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic926634-148-1.aspx

Please post new questions in a new thread. Thanks.

If you can't run checkDB, then there's going to be no way to repair this database (as checkDB is the thing that does the repair). Since you have no good...

Sorry, I don't understand what you meant by that last reply. Are you saying you can't run CheckDB, that you won't run checkDB or that it produces an error?

If it...