Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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