All Questions
2 questions
3
votes
1
answer
564
views
Reasons for not Globally enabling Trace Flag 2453 - Cardinality on Table Variables
I've been doing some reading on the improvements that Trace Flag 2453 can give on the performance of Table Variables by maintaining statistics and was wondering what would be the reasons you would ...
- 307
9
votes
1
answer
275
views
how come a table variable is improving the performance of a query in this circumstance?
for this specific case, that I will try to explain below, using a table variable is performing better than not using a table variable.
I would like to know why, and if possible, get rid of the table ...
- 16.6k