Microsoft KB Archive/325024

= Support WebCast: Effective Indexing and Statistics with SQL 2000 =

Article ID: 325024

Article Last Modified on 8/9/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q325024





Session Summary
This session will explain the different types of indexing mechanisms in SQL Server 2000. It will cover how to choose an effective index for a query, and it will discuss indexing techniques like covering indexes, index intersection, and index join. It will explain the role of statistics in using indexes effectively, as well as using the Index Tuning Wizard for maintaining proper indexes on the database

This is a Level 200 session that was recorded July 6, 2001 and presented by Sajal Dam. Sajal Dam is an Application Development Consultant and has been working at Microsoft for three years. He works with various Microsoft Premier customers to help tune their Web and WinDNA applications for performance and scalability, and he conducts SQL Server performance tuning workshops. His strengths include optimizing the performance of front-end Web server to back-end SQL Server.

Viewing the Presentation
To view, please click on the link: [javascript:fnViewMMC('http://support.microsoft.com/servicedesks/webcasts/seminar/shared/asp/view.asp?url=/servicedesks/webcasts/en/wc070601/manifest.xml'); View this Support Webcast] (Length: 1 hour 42 minutes)



This Windows Streaming Media archive requires an Internet connection of 28.8 Kbps or faster, and is best viewed with a minimum screen resolution of 800 X 600.

Additional Resources
Download presentation wc070601. This is a -KB Microsoft PowerPoint (.ppt) file.

If you do not have PowerPoint and you want a copy of the slides, use the PowerPoint Viewer (2,752 KB).

Read the transcript from this Support WebCast

Tell a friend about this Support WebCast

Provide Feedback on this Broadcast

Support WebCasts Home

Keywords: kbinfo kbdownload kbtshoot kbwebcastsupport KB325024

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.