RE: Memory Pressure – SQLServerCentral

SSCoach

Points: 16143

November 2, 2012 at 11:34 am

menon.satyen (11/2/2012)

Please go through the below link

http://www.sql-server-performance.com/2009/identify-missing-indexes-using-sql-server-dmvs/%5B/quote%5D

Careful with the missing index DMV's. it may suggest 2 indexes with slight differences that could be accomplished with one index. they are a good guide but not the be all end all of index planning.

Here is a good article on index planning and gail has many more at the same blog.

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]