Microsoft KB Archive/88489

= INF: Text/Image Data Page Calculation Formula Is Wrong =

Article ID: 88489

Article Last Modified on 2/11/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q88489



The &quot;System Administrator's Guide&quot; 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

Additional query words: database size

Keywords: kbother KB88489

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.