I don't have to worry about I/O because I use a SAN. RAID 5 is our backup strategy! I just made you a sysadmin, now you don't have to keep asking me for permissions I've changed all of the databases in production to use both AutoShrink and AutoClose Nope...
Tuning SQL Server has always been a black art. Luckily, SQL Server 2005 added a number of tools to give us a glimpse into its inner workings through Dynamic Management Views (DMV). In the MSDN article, SQL Server: Uncover Hidden Data to Optimize Application...
I just posted a new release of SharpDbSchema . Check it out, the web-based schema browser is my favorite new goody. This release includes... Added MySQL schema provider (requires ByteFX MySql Provider , download seperately) Added web-based schema browser...