O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

Understanding the way SQL Server 2000 stores, modifies, and retrieves data helps you to design databases for optimal performance.

Which index strategy to apply has a big impact on the overall performance of the database. Different uses require different indexing strategies.

Decision Support Systems (DSSs) are based on reading operations, which read many rows to produce a report, usually with data aggregation. Online Transaction Processing Systems (OLTP) are based in fast access to a small number of rows, producing modifications on the data, forcing index maintenance.

Many systems are a mixture of DSS and OLTP operations. SQL Profiler can help us to determine the actual workload, and the Index Tuning Wizard can suggest an efficient strategy ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required