Sean Lange (2/25/2011)
...there is not a table to log against. This is no different than any other variable type.
Not true: operations on table variables are logged, but don't participate in transcations.
Jason-299789 (2/25/2011)
Also consider that Table variables actually end up as unindexed tables in the tempdb anyway...
Not true: add a primary key or unique costraint and you can add indexes to a table variable.
Here's a great post by Gail Shaw on both myths: http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/
-- Gianluca Sartori