L' Eomot Inversé (10/14/2012)
Fun question.I wonder how many people will fail to notice that although you've got everything ready to create the index you haven't actually done so, so the view is not indexed and can't have statistics.
Correct answers: 79% (33)
Incorrect answers: 21% (9)
9/42 already failed to noticed this..
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter