Believe it or not, I have to agree with that MS support engineer, in my last work environment (my smallest db is 1+TB, it is more OLTP-like, and it is SQL 2005 EE), I have to set MAX DOP=1 to...
The Great Debate: Should You Shrink Databases?Commented on: 4 years ago
(November 17, 2009)
I believe for those against shrinking db, it is mainly because of concerns for bad performance thereafter. However on the other hand, there are tons of BUSINESS reasons that shrinking a db is a must...
Examining XML Plans in CacheCommented on: 6 years ago
(January 22, 2008)
It seems the download link and the hot links (such as listing 1, listing 2 etc)inside the article are still not working
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More