kevriley (7/3/2008)
Plus be careful when calculating the number of bytes per row, as SQL will store some data off-row if the on-row limit is reached - so whilst the spec says 8060 bytes per row, you can store more than that depending on the data types involved.
Plus you have the LOB data that's stored off 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