What are the index designing recommendations in sql server ? Or What are the criteria for index creation in sql server ?

Wow, people write books about it...

http://www.amazon.com/Microsoft-Server-High-Performance-Window-Functions/dp/0735658366

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/



MS SQL optimization: MS SQL Development and Optimization

MS SQL Blog: Large scale of database and data cleansing

Remote DBA Services: Improves MS SQL Database Performance