In SQL Server, how do you determine the average (average or expected) number of rows per page?
I know how to set the average and maximum line size, but I do not know how it relates to the actual rows / pages.
8060 bytes per page, 8 pages per extent ... Remember that if you line 4040 bytes You can only fit one line on the page
DBCC will show how many pages your table is using
Comments
Post a Comment