GilaMonster (9/27/2012)
Probably, but can't say for certain without a lot more info. The query, indexes and exec plan would help.
Agree, as usual, although I would probably phrase it as "highly likely" instead of "probably". I will add that I DEFAULT to using temporary tables and only switch to table variables in VERY exceptional situations.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service