Segments (Level 1)

Installing SQL Server

previous page next page

Installing SQL Server

Segments (Level 1)

SQL Server 6.x	SQL Server 2000
Indexes could be placed on segments using the CREATE INDEX statement.	Segments are no longer supported. However, CREATE INDEX can create an index on a filegroup. Remove all references to segments and replace with references to filegroups within a CREATE INDEX statement.
Tables could be created on a particular segment by using the CREATE TABLE statement.	CREATE TABLE references files and filegroups instead of segments. Remove all references to segments and replace with references to files and filegroups within a CREATE TABLE statement.
User-defined segments allowed the placement of database objects on certain devices for performance reasons.	Segments are no longer supported. Multidisk RAID devices generally provide a greater increase in performance with a lower associated administrative cost. Use filegroups for user-defined placement of data, indexes, or text. Remove all references to these segment-related system stored procedures: sp_addsegment sp_dropsegment sp_extendsegment sp_helpsegment Create, modify, or drop files and filegroups; and place indexes on files or filegroups using CREATE TABLE, CREATE DATABASE, ALTER DATABASE, and CREATE INDEX.

SQL Server 6.x

SQL Server 2000

Indexes could be placed on segments using the CREATE INDEX statement.

Segments are no longer supported. However, CREATE INDEX can create an index on a filegroup. Remove all references to segments and replace with references to filegroups within a CREATE INDEX statement.

Tables could be created on a particular segment by using the CREATE TABLE statement.

CREATE TABLE references files and filegroups instead of segments. Remove all references to segments and replace with references to files and filegroups within a CREATE TABLE statement.

User-defined segments allowed the placement of database objects on certain devices for performance reasons.

Segments are no longer supported. Multidisk RAID devices generally provide a greater increase in performance with a lower associated administrative cost. Use filegroups for user-defined placement of data, indexes, or text. Remove all references to these segment-related system stored procedures:

sp_addsegment
sp_dropsegment
sp_extendsegment
sp_helpsegment

Create, modify, or drop files and filegroups; and place indexes on files or filegroups using CREATE TABLE, CREATE DATABASE, ALTER DATABASE, and CREATE INDEX.

previous page start next page