Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kotsas
Yak Posting Veteran
65 Posts |
 Posted - 2002-01-24 : 03:17:27
|
| Can somebody can tell me how physicaly mixed extends goes to uniform, and does extends are physicaly continued pages in memory??Something more about physical desing |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-24 : 08:48:06
|
| The first 8 pages for a table are allocated from mixed extents. Once the table grows beyond 8 pages, all further space allocation is done through uniform extents. According to the definition in the BOL, extents always consist of contiguous pages. If you want to read about SQL Server internals in detail, I highly recommend a book by Kalen Delaney called "Inside SQL Server". Here is a chapter from it that addresses your question: http://www.microsoft.com/mspress/books/sampchap/4297a.asp-------------------If trainstation is a place where train stops, what's a workstation? |
 |
|
|
|
|
|
About allocating pages(uniform and mixed extends)