Avoiding Parameter Sniffing in SQL Server
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Thu, 20 Jun 2013 06:00:00 UT
Indexed on
2013/06/25
22:26 UTC
Read the original article
Hit count: 134
Filed under:
Parameter sniffing is when SQL Server compiles a stored procedure’s execution plan with the first parameter that has been used and then uses this plan for subsequent executions regardless of the parameters.
Get your SQL Server database under version control now! Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out… |
© SQL Server Central or respective owner