Sql Studio 2014 _hot_ -

Suddenly, the query ran again – 40 seconds. What? I checked the execution plan. Same indexes. Then I remembered: parameter sniffing. SQL Server 2014 didn't have the automatic plan forcing of later versions. I added OPTION (RECOMPILE) to the stored procedure and added WITH RECOMPILE to a frequently called function.

The dashboard query that had been timing out (45 seconds) dropped to . I sat back. The blue SSMS window – with its old-school toolbar icons and gray background – felt less like an IDE and more like a cockpit. sql studio 2014

Execute SQLManagementStudio_x64_ENU.exe (for 64-bit systems) as an administrator. Suddenly, the query ran again – 40 seconds