Randheer (2/17/2011)
This is the questions which other than the general indexes questions.What are criteria to define covering index and how we create it?
Please provide some details for this question.
Are you asking us so that you can update your blog? If so, do some research, start with the indexing articles I wrote for this site.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability