SQL Server Performance Forum – Threads Archive

Missing Indexes

I just thought I would post these. They are very informative and help you help the optimizer! http://www.sqlservercentral.com/columnists/aingold/2770.asp
http://msdn2.microsoft.com/en-us/library/ms345405.aspx I have seen other articles, but these are the best I have seen on the subject.
Mike Michael
MCDBA "The fear of the Lord is the beginning of knowledge,
but fools despise wisdom and instruction." Proverbs 1:7

There was a good article in SQL Mag recently by Kalen Delaney about these DMVs. I have recently used them to great affect to help performance on 2005. March 2007 issue, Instant DocID 94884

And also in April 2007
Use Missing-Index Groups for Query Tuning
Identify missing indexes that you could implement to improve query performance
http://www.sqlmag.com/Articles/ArticleID/95220/pg/1/1.html MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Yup, I have read those. love those two web pages more.<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> they are just more clear and verbose<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Just my opinion. I do read Kalen’s stuff all the time.. and Itzik<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Mike Michael MCDBA "The fear of the Lord is the beginning of knowledge, but fools despise wisdom and instruction." Proverbs 1:7

Guys
A suggestion if you do need to refer the links etc for a good readup, why not ask Webmaster to get you a login for Blog and then input your information, this way I believe its best to go about it. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

I think I will do that, but do people read them and do you get stats to see how many do? Michael
MCDBA "The fear of the Lord is the beginning of knowledge,
but fools despise wisdom and instruction." Proverbs 1:7

OH yes on the news manager client, appreciate your interest. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Webmaster asked me to wait until site migration. MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

same here. Michael
MCDBA "The fear of the Lord is the beginning of knowledge,
but fools despise wisdom and instruction." Proverbs 1:7

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] then you have to bear until it is finished. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</center>

]]>