MSDN: Index Tuning Wizard for Microsoft SQL Server 2000

By Bill Graziano on 4 October 2000 | Tags: Performance Tuning , Indexes

This article describes the Index Tuning Wizard in Microsoft SQL Server 2000. The Index Tuning Wizard simplifies the task of identifying which indexes to create in a table and also optionally generates scripts to create them by analyzing a user-supplied workload.

Link: MSDN: Index Tuning Wizard for Microsoft SQL Server 2000

Related Articles

Which is Faster: SAN or Directly-Attached Storage? (21 January 2008)

Using Included Columns in SQL Server 2005 (14 January 2008)

SQL Server Indexes: The Basics (26 November 2007)

Benchmarking Disk I/O Performance: Size Matters! (30 October 2007)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Introduction to Parameterization in SQL Server (7 August 2007)

Using Indexed Computed Columns to Improve Performance (16 January 2007)

SQL Server Storage Engine Team Blog (7 June 2006)

Other Recent Forum Posts

I need help with checking the sql query (4d)

Setting Min Server Memory (13d)

average duration increasing inline with exec counts (13d)

UOM parameter (19d)

maintenance job issue after upgrade to mssql 2022 (19d)

Easier/simpler way of importing an SSIS package -- help needed! (20d)

Why am I receiving an error about a column in the select list not being in an aggregate function or in the GROUP BY? (21d)

How to I insert records based on one to many relationship? (23d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site