• It is not documented in BOL. It may be documented in some of the books on SQL Server internals. If so, I don't remember which one(s).

    It is easy to prove simply set up a test where you are inserting sequential, ever-increasing data into a table so that there are no page splits, only allocations for new pages, and watch the performance counter.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]