Can I spread out a long running stored proc accross multiple CPU's?
- by Russ
[Also on SuperUser - http://superuser.com/questions/116600/can-i-spead-out-a-long-running-stored-proc-accross-multiple-cpus]
I have a stored procedure in SQL server the gets, and decrypts a block of data. ( Credit cards in this case. )
Most of the time, the performance is tolerable, but there are a couple customers where the process is painfully…