Comments posted to this topic are about the item Indexed view
Okay, still haven't had enough caffine this morning. I got this one wrong because i misread the question.
Hall of Fame
Your question states 'has to be on', but the answer says 'should be'. Is that the same thing as required, or just highly recommended?
Slip in the answer reasoning. Must be according to the reference.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
can't believe i missed this one !
Never bothered to check all these while scripting. It was mostly copy and execute but CONCAT_NULL_YIELDS_NULL is new to me.
All of theses set to ON, and also there are more other requirements while creating indexed view
Viewing 7 posts - 1 through 6 (of 6 total)