UMG Developer (12/18/2010)
As long as you understand the consequences and limitations...
I like to think I have a fairly good grasp, yes.
...and the optimizer can create decent plans with the row estimate it will use for the table variables. (It will always assume that it contains 1 row if I recall correctly.)
It will estimate one row unless WITH (RECOMPILE) is specified, or there is a statement-level recompile for any of the usual reasons; in either case table cardinality will be available.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi