Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2011-12-06 : 01:15:14
|
| Hope I'm wording this correctly, bit of a long shot, but here goes:-Currently I use the management DMV's to identify any new indexes that may improve performance of the queries that are used on my tables.I can also identify the least used indexes via the DMV's as well to help me manage the indexes better.To cut a long story short, does anyone have a script they are willing to share that will query existing indexes and find out if any of them contain the fields in the new index suggested by the DMV's or point me in the right direction for querying the DMV's looking for an existing index that uses some/all of the fields suggested by the DMV's.Cheerswd |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-12-09 : 03:08:44
|
| pretty sure someone posted a script to do that on here, you might want to try the SEARCH. My memory is probably wrong, but I think it may have been posted by: Michael Valentine Jones |
 |
|
|
|
|
|
Finding Indexes