SanDroid (4/12/2011)
GilaMonster (4/12/2011)
Piquet (4/12/2011)
Umm - there are TWO correct answers listed for this question (as described in the explanation), but only ONE can be selected. i.e.:- Inserts into Table Variables are not logged
- Version Store is not logged
...and you only get points for the second of these answers...
Inserts into table variables are logged. The explanation reads:
1. Insert (and update/delete) statements into table variables are logged - see "Changes to Table Variables are not logged" at http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables%5B/quote%5D
The blog post addresses three myths around table variables, including the myth that the changes aren't logged, sand proves them wrong.
Gila, As I see you and others have noticed, there are several things wrong with the question and answer. You should contact WayneS directly. The day of the question, it seems, he thought I was the only one that noticed.
I noticed nothing wrong with the question or answer, nor have I implied as much anywhere in this thread. In fact you are the only person complaining. Piquet simply misread the explanation.
And, for the record, I spoke with Wayne extensively on this before it was posted.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability