January 28, 2013 at 1:47 am
hi all,
Is the Data Page contains the data from a single table or multiple tables data.
🙂
January 28, 2013 at 1:52 am
A page is allocated to a table
An extent can be allocated to multiple tables.
An extent is what is created when new pages are required, it creates a 64k block, so 8 pages of 8kb each, hence why it is best to have your disks formatted in 64k blocks.
An extent can be mixed or uniform, mixed means that different pages in the extent are allocated to different tables, uniformed means that all 8 pages in the extent are allocated to 1 table.
http://msdn.microsoft.com/en-gb/library/ms190969%28v=sql.105%29.aspx
January 28, 2013 at 1:57 am
Thank you,
Great explanation
🙂
January 28, 2013 at 2:55 am
I liked this series, if you would like to check: http://www.youtube.com/watch?v=o5Pf5FHJHyU
January 28, 2013 at 3:13 am
SQL* (1/28/2013)
Is the Data Page contains the data from a single table or multiple tables data.
this wil help you http://msdn.microsoft.com/en-us/library/ms190969(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 29, 2013 at 2:25 am
anthony.green (1/28/2013)
A page is allocated to a table
or an index 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply