Yo, Is That Mary?
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
I like to put the index definition in a comment in the view definition. That way, if I have to alter the view for any reason, the index definition will be there in the comments so it will remind me to recreate the index.
Oh, that’s a great idea.