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 on 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.
Related Posts
- Common SQL Server Consulting Advice: Adding Indexed Views
- Getting The Top Value Per Group With Multiple Conditions In SQL Server: Row Number vs. Cross Apply With MAX
- Getting The Top Value Per Group In SQL Server: Row Number vs. Cross Apply Performance
- Software Vendor Mistakes With SQL Server: Not Using Filtered Indexes Or Indexed Views
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.