In this post, I am sharing about the Parameter Sniffing of SQL Server. I will discuss, why the query optimizer sometimes fails to choose a proper query plan. One day I experienced that one of my production stored procedure was not returning expected performance, and before two days, same stored procedure was running fine. At that time, I didn’t know … Continue reading SQL Server Parameter Sniffing