How do you get to limits of 8060 bytes per row and 8000 per (varchar, nvarchar) value?
Inside the Storage Engine: Anatomy of a record This is for SQL Server 2005 record header 4 bytes long two bytes of record metadata (record type) two bytes pointing forward in the record to the NULL bitmap fixed length portion of the record, containing the columns storing data types that have fixed lengths (e.g. bigint, … Read more