Sql server temporary table limitation

Question

Are there any restrictions on writing to the temporary table. I tried with 1.3 million records. I may have to deal with billions in the future, as the application requires. Is it possible? If I could know the record limit ... I could try to split the records from the db source and manage within the limit. thanks in advance

Answer 1

The differences between tempdb and any other database are minimal, especially when it comes to limits.

If you can save it in the user table, you can also save it in the temporary table. It should not fit into RAM, since tempdb is stored on disk just like any other database (only with more aggressive caching and less logging).

Source: http://msdn.microsoft.com/en-us/library/ms190768.aspx

Answer 2

A temporary table is the table that should be applied: Maximum capacity for SQL Server

Rows in a table

Limited available memory

Answer 3

, ( - ). , tempdb, .

Answer 4

tempdb , tempdb (.. ).

Answer 5

1000 , T-SQL INSERT, .

The number of row value expressions in the INSERT statement exceeds
the maximum allowed number of 1000 row values. 

https://dba.stackexchange.com/questions/82921/the-number-of-row-value-expressions-in-the-insert-statement-exceeds-the-maximum

Answer 6

(.. ) , , temp.

, , .