Home > Top 10 SQL Server indexing tips to improve performance
Top 10 tips:
EMAIL THIS LICENSING & REPRINTS

Top 10 SQL Server indexing tips to improve performance

22 Jan 2007 | SearchSQLServer.com

Expert advice on database administration
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

Significantly improve your SQL Server performance through proper indexing choices. We've tallied our most popular tips on the topic of indexes so you'll be able to quickly get the answers to your indexing questions. Learn how to weed out valueless indexes, design high performing indexes and query your existing SQL Server indexes.

#1 -SQL Server 2000 indexing dos and don'ts
In the second part of this three-part feature, Edgewood Solutions' Jeremy Kadlec outlines best and worst practices for indexing in SQL Server 2000.

#2 -Indexes made handy in SQL Server
Indexes should be reviewed to ensure prime performance. Weed out valueless indexes in SQL Server, while identifying the best indexes for your application.

#3 -Partition indexes for improved SQL Server 2005 performance
SQL Server 2005 index partitioning allows you to distribute the load for a given index across multiple files. Learn how to create an index with partitioned data.

#4 -Stored procedures: Create and delete constraints and indexes
This collection of six stored procedures will help you create and delete constraints and indexes.

#5 -Tricks for using the Index Tuning Wizard
Learn how to improve overall SQL Server 2000 performance with these Indexing Tuning Wizard tricks from Edgewood Solutions' Jeremy Kadlec.

#6 -Undocumented stored procedure: Repair table indexes with sp_fixindex
One undocumented stored procedure in SQL Server 2000 can be used to repair a corrupted table index. This tip explains how to use sp_fixindex to keep SQL Server running smooth.

#7 -Undocumented stored procedure: Find space occupied by all tables and indexes
Here's a quick way to find the space occupied by all tables and indexes in a SQL Server 2000 database.

#8 -Solving SQL Server 2000 index fragmentation
Edgewood Solutions' Jeremy Kadlec explains how indexes become fragmented and how to maintain beneficial indexes to ensure high performance.

#9 -Indexing Q&A: Answers to your common indexing questions
Know how to choose proper indexes for your business situation. In part one of this two-part indexing series, Edgewood Solutions' Jeremy Kadlec answers common indexing questions.

#10 -Clustered and non-clustered indexes in SQL Server
Rules for using a clustered vs. a non-clustered index are tough to decipher. In this tip, you'll see the fundamentals to consider when making your choice, along with some best practice techniques. Get an overview of tradeoffs and proper index implementation, as well as other areas involved in your decision, including partitioning and storage arrays.

More information on this topic:

  • Expert answer: Index types in SQL Server 2005
  • Book excerpt: Quick steps: 12 indexing tips in 12 minutes
  • Book excerpt: Creating indexes using the Enterprise Manager



    Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


    RELATED CONTENT
    SQL Server performance and tuning
    Virtual database storage for SQL Server: Friend or foe?
    Tutorial: SQL Server 2005 Analysis Services
    Tutorial: Migrating to SANs from local SQL Server disk storage
    SQL Server memory configurations for procedure cache and buffer cache
    Using the OUTPUT clause for practical SQL Server applications
    Check SQL Server database and log file size with this stored procedure
    SQL Server PerfMon counters for access methods and buffer manager
    Find size of SQL Server tables and other objects with stored procedure
    Monitor SQL Server disk I/O with PerfMon counters
    SQL Server tempdb best practices increase performance

    Microsoft SQL Server
    Upgrade live applications to SQL Server 2005 for high availability
    How to use rank function in SQL Server 2005
    SQL Server high availability when upgrading to SQL Server 2005
    Secure SQL Server from SQL injection attacks
    Create a computed column in SQL Server using XML data
    SQL Server memory configurations for procedure cache and buffer cache
    How insiders hack SQL databases with free tools and a little luck
    Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003
    Using the OUTPUT clause for practical SQL Server applications
    Tips for moving from SQL Server local disk storage to SANs

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    contiguity  (SearchSQLServer.com)
    contiguous  (SearchSQLServer.com)
    drilldown  (SearchSQLServer.com)
    hashing  (SearchSQLServer.com)
    hybrid online analytical processing  (SearchSQLServer.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary


  • HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




    All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
      TechTarget - The IT Media ROI Experts