We have found on our 64 bit servers that setting MaxDOP to a lower value not to exceed the number of physical processors helps reduce CPU utilization. You may...

TheSQLGuru (3/19/2008)

---

Jeff Moden (3/19/2008)There is still to this day one VERY important tempdb locking issue if you have a high volume of temp object creation/drops. The SGAM (and one...

Yes, I had a database like that and that's how I...

magarity kerns (4/9/2008)

---

I picked the 312 answer because it was closest to what I calculated and the thing told me I was wrong and that 159 was the correct answer....

I just figured it had to be larger than 300 and guessed since I knew someone would provide a good explanation of how to calculate it precisely. Thanks Hugo...

You might try rebuilding all the indexes with 100% Fill factor, run DBCC updateusage and then try shrinking again.

Did you run a DBCC Checkcatalog and does it return without error? I have seen situations where orphaned tables (the columns exist in syscolumns but the objectid is...

SQLZ (4/2/2008)

---

There's an even neater trick in Management Studio.

Expand the table, select the Columns folder and drag it into the query window - all columns are added in a comma-seperated...

So when you execute :

DBCC Shrinkfile (1,1)

What does it return?

I would have to agree with Grace Hopper. She was a priceless jewel.

Poorly worded or not, I would never do an in-place upgrade.

Mine was installed properly to begin with and was working. It suddenly stopped working. The only thing I know that changed was a Microsoft Windows update. ...

Mine hangs on the simplest of queries (select * from table) and then eventually throws the generic error that you mentioned.

Since it hangs at "Submitting Configuration Information" ...

Yes, I agree. I can only get it to work with certain queries.

Thank you for the response. And yes I employ that method as well. I use the DMV's more than DTA but sometimes it is handy to be able...