Post reply

Threshold for memory

  • September 11, 2006 at 6:57 am

    #367324

    Hello Everybody-

    I am looking for some answers on below queries,

    1. How many rows of data can be contained in the data cache, here in case of a temporary table (# tables)?

    2. When would SQL server decided to have the temp table on tempdb instead of data cache?

    I did some google around but couldn't conclude anything.

    Thanks in advance!

    Thanks!

    Viking

  • September 11, 2006 at 7:25 am

    #659617

    #table_name (local), ##table_name(global) are always created in tempdb on disk. Check this article which will provide you better insight for all temp table issues.

    http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html

     

     

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

Viewing 2 posts - 1 through 1 (of 1 total)

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