create table test
(
	col1	nVARchar(4000),
	col2	nVARchar(4000),
	col3	nVARchar(4000)
)

insert test values (cast (replicate('*', 4000) as nvarchar(4000)), cast (replicate('*', 4000) as nvarchar(4000)), cast (replicate('*', 4000) as nvarchar(4000)))
insert test values (cast (replicate('*', 4000) as nvarchar(4000)), 'test', 'test')
insert test values ('test', cast (replicate('*', 4000) as nvarchar(4000)), 'test')
insert test values ('test', 'test', cast (replicate('*', 4000) as nvarchar(4000)))

select * from test

dbcc showcontig ('test') with tableresults

select * from 
sys.dm_db_index_physical_stats(db_id(),object_id('test'), null, null, 'detailed')