SQL Server: What happened, when Row Overflow and Data Exceeding 8KB?

In the previous article, I discussed the 8KB data page of the SQL Server, but what happened when the row is larger and cannot fit into a single 8KB page? Each row is strictly prohibited to use only 8KB size per data page, but the data type like char, varchar, nvarchar, and varbinary require more … Continue reading SQL Server: What happened, when Row Overflow and Data Exceeding 8KB?