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: 395
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
