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.
Performance impact of large data rows. That is rows that are greater than 8096 bytes.
Share this highlighthttp://www.safaribooksonline.com/a/microsoft-sql-server/18680/