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.
Well stated. I have yet to need a proper cursor (some consider the WHILE loop a cursor, and I use it to populate my date dimensions) but I have it in the back of my mind. I've seen too many use triggers and cursors w/o regard for other possibilities, ultimately to the detriment of the system.