Viewing 3 posts - 1 through 3 (of 3 total)
Well I did say "can" but they are memory objects and wont create anything in tempdb, admittedly small temp tables will probably behave similarly, and as I alluded to because...
December 29, 2014 at 4:36 pm
I have other issues with this article.
We have found that parameterised queries do not seem to work well. The optimiser creates an execution plan which is not relevant to particular...
December 29, 2014 at 2:30 am
Often is a key word
Table variables can be much quicker but also if they get too big can bring the server to a halt.
December 29, 2014 at 2:24 am