O'Reilly logo
  • Klaus Nji thinks this is interesting:

Be aware that having data rows that require a row-overflow page increases the I/O cost of retrieving the data row. Querying and performing other select operations, such as sorts or joins on large records that contain row-overflow data, also slow processing time because these records are processed synchronously instead of asynchronously.


Cover of Microsoft® SQL Server 2012 Unleashed


Performance impact of large data rows. That is rows that are greater than 8096 bytes.