Home Forums SQL Server 2008 T-SQL (SS2K8) Query tanking longer when created as SP RE: Query tanking longer when created as SP
f_ernestog
Ten Centuries
Points: 1187
More actions
January 29, 2013 at 10:09 am
#1582244
I added parameter sniffing to the SP (no need to look it up, just didn't remember it as an strategy to improve SPs...) and now it came back quicker than the script running in SSMS, which is great.
Thanks for your help.
Frank.