INF: How DATALENGTH Determines the Length of Text Fields (75277)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q75277
The DATALENGTH function does not need to traverse the entire text page
chain to determine how long the text field is, because the length is
stored on the first page in the chain. Therefore, although SQL Server
must de-reference the pointer stored in the row on the data page to
determine the location of the text page, then read the text page, the
overhead is small.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbProgramming KB75277 |
|---|
|