Chapter 1: Controlling Physical Data Placement

This chapter explains how to improve performance by controlling the location of tables and indexes.

To make the most of physical database tuning, understand these distinctions between logical and physical devices:

Use sp_helpdevice, sp_helpsegment, and sp_helpartition to get more information about devices, segments, and partitions.