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: | Minor | Last Reviewed: | 2/11/2005 |
---|
Keywords: | kbother KB88489 |
---|
|