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?
(November 16, 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 Cache
(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
Over 50 hours of recorded sessions. Including topics on:
• Windows Server & Windows 8
• SQL Server
• Platform Development Tools
Known for its unbiased content, this year’s IT/Dev Connections provides deep training on the technologies that run your business.
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More