Erik Darling starts a new series:
This aligns my stored procedures with the necessary settings to accomplish a couple things:
- Allow the optimizer to use indexed views, filtered indexes, and computed columns
- Avoid errors when modifying tables involved with indexed views, filtered indexes, and computed columns
Click through to see what Erik sets by default. It’s a good list, though a bit more than I think to do. Probably because I haven’t been burned enough yet.