• 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).

    So if every row takes, say, 4100 bytes, each would take a whole page, with the rest of that page unuseable except to expand the existing row.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.