Making SSRS reports faster: get rid of Parameter Sniffing

Is your SSRS report running slowly? Are you using a stored procedure to pull the data and pass them to report? If your answer to these questions is yes, then you are a victim of SQL Server's Parameter Sniffing. The first question is, what is Parameter Sniffing? It refers to SQL Server's effort to reduce … Continue reading Making SSRS reports faster: get rid of Parameter Sniffing