Timeoute expired. The timeout period elapsed prior to completion

[Kristen]

@ScottPletcher

QL Server does a page split: it creates another data page, copies roughly 4,000 bytes of data to the new page, and leaves the other ~4,000 bytes on the existing page. That is the fragmentation.

Thanks Scott. Should I not be seeing the fragmentation with dm_db_index_physical_stats ?

I don't want to pollute this thread I'll post my test code in a new thread and hopefully someone can tell me why it isn't causing fragmentation.

http://forums.sqlteam.com/t/fragmentation-test-of-clustered-index-with-large-lob-updates/6271