SQL Server segments can improve SQL Server performance by giving you more control over where you place data on database devices. A segment is a subset of one or more database devices and is available to a particular database. Particular segments can be allocated to specific tables or indexes.
Note The use of segments introduces administrative complexity and the possibility for error. In most cases, hardware-based RAID or Windows NT software-based RAID are recommended instead.
For information about setting up segments, see Using SQL Server Segments, later in this chapter.