Saw something similar in the past; but it was related to MAXDOP.... I would google maxdop and try setting the max degree of paralellism to 1 if it's a multi-processor...

Probably don't want to shrink the...

Could be.... I know backup compression does yield better results overall in most cases...

Wonder what the performance tradeoff is for page and row compression....

Wow! That sure was an interesting problem.... Glad it worked ok, I'd probably be up nights though worrying over that DB and if anything was lost....

umailedit (7/11/2008)

---

Contrarily I love to exercise a lot even though it is physical labor, I love to pump Iron. In fact I have my own gym.

How many techies...

Phil Melling (7/11/2008)

---

My wife and I moved into our house a couple of years ago, and since it had previously been rented out to students it needed gutting and putting...

Definately a DIY'er.... I've done everything from built sheds, electrical, plumbing, fix the car, tile work... these days though I'm doing less stuff like that and sticking to SQL server....

Well done!

I thought the article was very informative..

I have to wonder if the people you're seeing are the exceptions or the rule....

I know one certified person who I worked with that didn't have a clue, and about...

That's kinda scary... was a while ago I took those exams, but I know there were questions about AWE, /3gb and max server memory on the exams I took....

Jeff,

Was it a test DB with space issues? Dunno why anyone would want do do that....

Mark

Learned something new today... STATIC is faster, tested in a sproc I was trying to optimize.

Will probably end up rewriting it completely, need more speed...

Good article, but it would have been good to proofread it for grammer and typos...

Brad McGehee posted a pretty good article about this topic:

http://www.simple-talk.com/sql/database-administration/professional-certification-for-dbas/