Viewing 3 posts - 1 through 3 (of 3 total)
For example Microsoft SQL Server 2008 R2 Unleashed, under the "General T-SQL Performance Recommendations" section. There (page 1655) I read the following:
You should use table variables instead of temporary tables...
March 28, 2011 at 2:54 pm
#1304592
May I ask why you prefer temporary tables above table variables?
Almost all the books I have read about SQL Server state that it's better to use table variables than temporary...
March 28, 2011 at 1:58 pm
#1304561
Maybe UNION ALL the two sets and include a column to specify which of the sets is the copy?
March 28, 2011 at 9:08 am
#1304416