Database Pages and Extents (Level 2)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| A database extent consisted of eight 2 KB pages. | A database extent consists of eight 8 KB pages. Different objects can now share an extent or an object can have its own extent. A table and index both have a minimum of two pages.
Expect different results as compared to earlier versions of SQL Server. Adjust disk space requirements for adequate database storage. For more information, see Pages and Extents. |