• Bhuvnesh (10/19/2012)


    Chad Crawford (10/18/2012)


    The query is executing the sp_columns system stored proc, which returns information about a table column, given the table and column name.

    Why dont you try sys.columns or information_schema

    That would be much better. I've asked for them to pull the reference to sp_columns completely out of the code, since they are only using it to get a list of columns they need to do an insert. Until that can be coded, QA'ed and deployed, we still have to suffer through. Do you have any ideas why performance on a system proc would suddenly change? It was working fine for years, then suddenly became an issue? Normally I would think it was statistics, but it doesn't seem you can update stats on system tables and that would imply that we had made a bunch of schema changes, which we did not. 🙁

    Chad