question

UnishSQL avatar image
UnishSQL asked

Pages In sql Server

Is they **any rule for storing** data in pages? For example is there a rule like: "From 0-10 pages only that particular data should be stored."
sql serverstoragepage
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
DenisT avatar image
DenisT answered
I would start with reading these blog posts by Paul Randal: 1. [Inside the Storage Engine: Anatomy of a page][1] 2. [Inside the Storage Engine: Anatomy of an extent][2] 3. [Inside the Storage Engine: IAM pages, IAM chains, and allocation units][3] 4. [Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps][4] It should give you a better inside of how the storage engine works. [1]: http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-anatomy-of-a-page/ [2]: http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-anatomy-of-an-extent/ [3]: http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-iam-pages-iam-chains-and-allocation-units/ [4]: http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-gam-sgam-pfs-and-other-allocation-maps/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.