Subscribe to this blog
Archives: December 2011
Notes from Mission Critical Environments in SQL Server 2012, Webinar by Marc Theoret
The other day I sat in while Marc Theoret gave a great overview of the what is coming in SQL Server 2012 - Enjoy the summary thanks to SkyDrive
0 comments, 487 reads
Posted in The Database Hive for SQL Server DBAs on 11 December 2011
With A Little Bit of Care, You Can Use the DMVs to Auto-Create Some Missing Indexes, Here Is How (but with Caveats)
Here's the useful join from a number of Index related DMVs - it grabs the top 50 possible missing indexes ordered by priority
select top 50 priority = avg_total_user_cost * avg_user_impact *(user_seeks + user_scans)
,d.statement
,d.equality_columns Read more
0 comments, 647 reads
Posted in The Database Hive for SQL Server DBAs on 2 December 2011
SQL Server 2008 R2 Installation Step by Step Guide - Saving System Admins, DBAs, Developers and Support Technicians A Wee Bit O' Misery
I've uploaded to SkyDrive a complete step by step guide for a SQL Server 2008 R2 installation because I prefer to see this done correctly than butchered, hope it helps save some time for those dealing with this vast task, including how to install a service pack and where to… Read more
4 comments, 7,379 reads
Posted in The Database Hive for SQL Server DBAs on 2 December 2011