• sanket kokane (11/30/2012)


    ScottPletcher (11/29/2012)


    Depends on how many bytes in table, and how long a row is.

    A SQL page is 8K, with 8060 total bytes available for data. Each row resides on a single page (excluding special column types).

    you sounds like only one row per page ,right ?

    No, he said each row resides on a single page, not each page contains only one row.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass