Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Read more

0 comments, 719 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)

An Automagic Index Creation Script? No, but a start to deal with Missing Indexes

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, 1,125 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

5 comments, 16,892 reads

Posted in The Database Hive for SQL Server DBAs on 2 December 2011