Wednesday, February 17, 2016

TableVariables vs. TempTables


in short:
- TableVariables don't change the schema, but are also executed in tempdb
- TempTables have statistics in comparison to TableVariables (query fast, costs after change)

I personally use TableVariables more often than TempTables, because I can't forget to drop them :-)

long version:

kind regards,

No comments: