Performance Tuning with OPTIMIZE FOR UNKNOWN

Today I ran into a performance/scalability problem with a group of stored procs I’d written earlier this week.  All the procs passed basic unit-testing, but once I increased the load from processing 100 records to 100,000 records…you know, to make sure it scales and stuff…the test went from < 3 seconds to over 35 minutes!!  […]