sanket kokane (11/30/2012)
ScottPletcher (11/29/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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability