Improving Sql Server Performance

How to create Missing Indexes based on the DMV values

http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx

How to Identify missing Indexes based on DMV values

http://msdn.microsoft.com/en-us/magazine/cc135978.aspx