amenjonathan (11/17/2010)
Indexed views and triggers: two things to avoid if at all possible. Next up: Cursors are good! 😀
Please explain.
Or, if we are just throwing terms without any backing, I'll offer:
* Indexed views, when used with care, are an invaluable performance tool.
* Triggers are great to guard consistency, but only when standard constraints fall short.
* Cursors, though heavily overused by new users, certainly have their place in the expert's tool box.