Richard Sisk (1/11/2011)
Would have got it right except I was thrown by the apparent conflict that the question was for SQL Server 2008 but the last option clearly asks about SQL Server 2000. Why would I select a SQL2000 option if the question is about SQL2008?Other than that, great question. I learned some new stuff today.
You may need to reread the question & some of the comments.
First, there was no SQL2000 option. Instead the option was that the query performance on SQL Server 2008 for a query using TOP with ANSI_PADDING OFF may be worse than with SQL Server 2000. SQL Server 2000 is referenced in this option, but the topic is the performance of TOP with ANSI_PADDING OFF in SQL Server 2008.
Second, two answers of the QOTD are incorrect.
a) The usage of an index on a computed column, and
b) the possibility to alter an index on a computed column.
Lesson learned: Do not trust Microsofts documentation 😉
Best Regards,
Chris Büttner