Ananth@Sql (6/18/2013)
Thanks Gila Monster for the reply.But There is an exception with out searching which procedures are getting usedthe table and what are the columns getting used is it possible to identify the non clustered index columns?
No. You can use tools like the SQL Server Profiler and DTA to get some suggestions.
But these are only suggestions which should never be accepted without proper analysis and testing.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/