This quiz is not really a generic question about changing an index key column to be an included column; it's about a behavior noticed by a reader in one particular query.  Dejan Nakarada-Kordic from New Zealand sent me a very interesting puzzle. He had a reproducible query for which he thought an existing nonclustered index should be used, ...

When an issue comes up more than once in a short period of time, I figure it is a message from the Universe. I might even assume it is a gift of blog fodder. So I won't turn down the gift, even if it means another juicy post before the end of year, much to Denis' disappointment. The issue is SQL Server 2005 ''Included Columns''. There was a post ...