INF: Text/Image Data Page Calculation Formula Is Wrong (88489)



The information in this article applies to:

  • Microsoft SQL Server 4.2x

This article was previously published under Q88489
The "System Administrator's Guide" incorrectly states in Appendix A on page 250 a formula to calculate the number of text/image pages that will be used for a single entry. The documentation states:
   The text chains that store text and image data have 112 bytes of
   overhead per page. Use the following formula to calculate the
   number of text chain pages that a particular entry will use:

      Data Length / 1936 = Number of 2K Pages
		

This formula is incorrect. The actual maximum amount of data that can be stored on a text/image data page is 1800 bytes.

To correctly calculate the number of text chain pages that a particular entry will use, the formula should be:
   Data Length / 1800 = Number of 2K Pages
		

Modification Type:MinorLast Reviewed:2/11/2005
Keywords:kbother KB88489