title: 8078 bytes in 8060 B datapage (SQL Server)?
body: <p>It is written everywhere that data in SQL Server is written in pages of 8K (8192 B) each with 8060 bytes for data and the rest is overhead (system info).</p>
  
  <p>Though, the recent article [1] gives code example illustrating, as I understood, that 8078 bytes of data fit into a page.  </p>
  
  <p>What do I miss in understanding 8,060 B per per page?</p>
  
  <p>I verified the code on x86 SQL Server 2008 R2...  </p>
  
  <hr>
  
  <p>Update:   </p>
  
  <p>Did I see an answer telling about follow-ups to [1]? I pity that I did not mark that as helpful (to me) and comment immediately...  I just wanted to investigate more myself before responding...</p>
  
  <hr>
  
  <p>Update2:  </p>
  
  <p>I posted subquestion [2]  </p>
  
  <p>[1]<br>
  How table design can impact your SQL Server performance?<br>
  <a href="http://sqlserver-training.com/how-table-design-can-impact-your-sql-server-performance/-" rel="nofollow noreferrer">http://sqlserver-training.com/how-table-design-can-impact-your-sql-server-performance/-</a>   </p>
  
  <p>[2]<br>
  How to come to limits of 8060 bytes per row and 8000 per (varchar, nvarchar)?<br>
  <a href="https://stackoverflow.com/questions/3793022/how-to-come-to-limits-of-8060-bytes-per-row-and-8000-per-varchar-nvarchar">How do you get to limits of 8060 bytes per row and 8000 per (varchar, nvarchar) value?</a></p>