MSDN: Improving Performance with SQL Server 2000 Indexed Views

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

This article describes the new indexed views capability of SQL Server 2000 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.

Link: MSDN: Improving Performance with SQL Server 2000 Indexed Views

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

Need To Generate Shift Rotation Weekwise Rather 7 Day Wise For The Yearmonth 202508 (6d)

Improving update statistics process for 6 big tables (16d)

Peer to Peer Replication is not working between 2 different machines (16d)

SQL HELP in SSMS: The query references an object that is not supported in distributed processing mode (50d)

Subscription sends report with data to one user but empty report to other users (52d)

Pivot Tables in SQL (59d)

Can't restore backup; SSMS says my user account directory is empty (60d)

REPL55012 error (86d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site