Post reply

No of rows in Temporary Table

  • April 15, 2013 at 11:54 pm

    #292276

    What is the maximum number of rows can be stored in a emporary table?

  • April 16, 2013 at 12:04 am

    #1606699

    The only limit is the size of your storage, or the maximum database size (524,272 TB, which is beyond any storage you're likely to have)

    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

  • April 16, 2013 at 12:10 am

    #1606701

    ops sorry for the confusion. I mean the rows in a Table Variables NOT temporary tables.

  • April 16, 2013 at 12:37 am

    #1606709

    Exactly the same answer.

    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

  • April 17, 2013 at 12:21 am

    #1607126

    Thank you so much Gail.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply