拍拍尘土

| Hi,
|
| How do I find the max row size for a particular table?
| This was the error I recieved while execting my proc with the relevant
| i/p I need to:
|
| "cannot sort a row of size 8192, which is greater than the allowable
| maximum of 8094"
|
| I also understand that the max bytesize of a row is 8060 bytes.But
| whtz this 8094?
|
| TIA,
| Seetha

Each datapage can actually 8192 bytes. This is because each kb is 1024
bytes. The Microsoft documentation specifies that a page header
contains 96 bytes of overhead. This is for keeping track of the page
within the system, kind of like a File Allocation Table on your hard
drive. This leaves 8096 bytes for data and row offsets (pg 247, Inside
SQL Server 2000). You get 8094 because each row has a 2 byte offset.
There is a decent article that goes into more detail at
"http://www.sqlservercentral.com/columnists/sjones/pagesize_printversion.asp"
if you're interested. Also, "Inside SQL Server 2000" by Kalen Delaney
is a great resource.

--Bryan