What do you Know about the SQL Server Data pages ?

  • Article

SQL Server page is 8K so remember when you format your hard disk. Create it in a 64K clusters for the best performance. Let’s no more about the SQL Page

· 96 Bytes for the page Header

· 8096 for the page rows with a limits 8060 bytes Only for rows.

· 2 bytes in the end of the page determine the location of each Row inside the page

· Rows aren’t sorted inside the page but the pointers for it sorted according to the index.

· When SQL writes the rows if the remaining of the page won’t fit the whole row, SQL leaves this page and start a new page.

I hope this may help you with your next SQL installation