AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Saturday, March 22, 2008

SQL Server 2005 Missing Indexes Feature

Very cool feature for SQL Server 2005 - Missing Indexes Feature.  It uses dynamic management objects and Showplan to provide information about missing indexes that could enhance SQL Server query performance. So you can just run a query to find out which indexes are missing. Of course it can't replace developer or DBA, who certainly knows better how to fine tune DB, but can help to do so.

Here a blog post of Russian MVP Alexander Gladchenko, who pointed me to this feature.

Technorati tags: ,

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home