title: Temporary table record limit in Sql server
body: <p>Is there any limits for the record in the temporary table.. I have tried with 1.3 million records.. may be i have to deal with billions in the future as the application demands.. Is it possible?  If i could know the limit of records.. i could try to split the records from source db and manage within the limit. Thanks in advance</p>