Winnipeg SQL Server UG April Event – How To Do An Index Review

Posted by D'Arcy Lussier on Geeks with Blogs See other posts from Geeks with Blogs or by D'Arcy Lussier
Published on Fri, 26 Mar 2010 15:30:38 GMT Indexed on 2010/03/26 15:43 UTC
Read the original article Hit count: 389

Filed under:


April Event - How to Do an Index Review

April 14th, 2010 5:30 - 8:00
17th Floor Conference Room, Richardson Building
One Lombard Place, Winnipeg
Pizza and Drinks Provided!

Did you know that SQL Server 2005+ keeps query execution statistics, index usage statistics and even missing index statistics?  Learn how to access this information and use it to help you make good decisions about what your database really needs in terms of indexes in a lot less time than you might think an index review should take.  There are 6 or 7 (depending on your version of SQL server) DMVs (dynamic management views) to look at which reveal a lot about your database and how you can improve its performance.

To register for this event, please click HERE to register!

© Geeks with Blogs or respective owner