• Just to add my 2 pence, did you know that you can query the dmv's and retrieve all the queries where the plans include operations on the index. So you should actually get the queries and see why they are scanning that index.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]