sanket kokane (11/30/2012)
Depends on how many bytes in table, and how long a row is.
A SQL page is 8K, with 8060 total bytes available for data. Each row resides on a single page (excluding special column types).
you sounds like only one row per page ,right ?
No, he said each row resides on a single page, not each page contains only one row.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass