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...