Slow insert into table variable versus temp table
102220
Table variable poor performance on insert in SQL Server Stored Procedure
153327
if block fails to create temp table in a procedure
24417
"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"
89072
Improve INSERT-per-second performance of SQLite
37349
Why does my query run fast in Environment A, but slow in Environment B?
129898
INSERT vs INSERT INTO
52090
Temp table to Master table insert or update with auditing and logging
128783
How to save select query results within temporary table?
13858
Being that string substitution is frowned upon with forming SQL queries, how do you assign the table name dynamically?
36268
Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?
93412
Why does SQL Server use a better execution plan when I inline the variable?
64112
Do temp variables slow down my program?
47496
What's the difference between a temp table and table variable in SQL Server?
63636
Lock time not involved in MySQL slow query selection?
138284
Are individual queries faster than joins?
18890
INSERT INTO vs SELECT INTO
63140
SQL Server nvarchar(max) vs nvarchar(n) affects performance