An example...

-- Prepare sample data

CREATE TABLECharlesZ

(

i INT IDENTITY(1, 1) PRIMARY KEY CLUSTERED,

ss VARCHAR(MAX) NOT NULL

)

-- Insert short string

INSERTCharlesZ

SELECT'Peter Larsson'

-- Insert long string

DECLARE@ls VARCHAR(MAX)

SET@ls = REPLICATE('Z', 8000)

SET@ls = @ls + REPLICATE('Z', 8000)

INSERTCharlesZ

SELECT@ls

-- Display table data

SELECTi,

ss,

DATALENGTH(ss) AS Characters

FROMCharlesZ

-- Display index page information

DBCC IND(Test, CharlesZ, 1)

-- Display in-row data

DBCC PAGE(Test, 1, 196, 3) WITH TABLERESULTS

DROP TABLE CharlesZ