GilaMonster (12/23/2013)
It may be worth looking through the codebase for other similar procedures. I've typically found that if this kind of pattern is used in one place, it's used in a lot others too.
+1, usually when this type of code exist in one place, it exists elsewhere as well, and it is worth fixing everywhere in one major push than combating performance issues one by one over time.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]