• 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.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/