SQLServerPedia

Your community knowledge base Powered by Quest Software
  • SQL Server Wiki
    • Architecture & Configuration
    • Business Intelligence (SSAS, SSIS)
    • Database Administration
    • Monitoring SQL Servers
    • Performance Tuning
    • SQL Server Links
    • SQL Server Tutorials
    • Transact SQL Coding Techniques
    • Transact SQL Coding and Naming Standards
    • Transact SQL Code Library
    • How to Write and Edit Articles
  • Pulse New!
  • Blog
    • Professional Development
    • Database Design
    • Podcasts
    • Site Updates
    • Syndicate Your SQL Server Blog
  • Podcasts
  • Bloggers
  • Contribute
  • Log in

Index Related DMV Queries

  • Page
  • Discussion
  • View source
  • History

From SQLServerPedia

Jump to: navigation, search

See Also: Main_Page - Transact SQL Code Library

The following Index Performance Tuning queries are included in the T-SQL Code Library:

  • Find Tables Without Primary Keys - also known as heaps.
  • Find Indexes Not In Use
  • Find Missing Indexes
  • Find Queries in the Plan Cache That Are Missing an Index

Have Problems with These Queries?

You can add questions by clicking on the "Discussion" tab at the top of this article. The authors will see your comments and respond.

Retrieved from "http://sqlserverpedia.com/wiki/Index_Related_DMV_Queries"

Editor In Chief

 
Iain Kick

Since 2005 Iain has worked in the UK for Quest Software as a lead consultant on their SQL Server products. He meets with customers and covers pre-sales…

Read More »

Subscribe

  • RSS

Top Searches

  • SQL Server Date
  • SQL Server Download
  • SQL Server Functions
  • SQL Server Management
  • SQL Server Service
  • SQL Server Tutorial
  • Database Hosting
  • Database Transaction

Powered by MediaWiki  |  © 2010 Quest Software, All Rights Reserved.  |  Privacy Policy  |  Terms of Use  |  Contact Us