Listing 1: Creating a Table to Display LOB Storage Details

USE tempdb
GO
CREATE TABLE hugerows
   (a char(1000),
    b varchar(8000),
    c text )
GO
INSERT INTO hugerows
   SELECT REPLICATE('a', 1000), REPLICATE('b', 1000),
      REPLICATE('c', 10000)