Forum Discussion
RandyLP7
May 23, 2025Copper Contributor
Stored Procedure runs long the first run, then runs faster
I have a Stored Procedure that does the following: Creates 2 Temp Tables Inserts into first Temp Table Inserts into second Temp Table from 20 Tables, plus joining to the first Temp Table and has ...
olafhelper
May 26, 2025Bronze Contributor
Compilation of a stored procedure takes some milliseconds.
I guess it's more related to buffer pool = SQL Server data cache, see
Memory management architecture guide - SQL Server | Microsoft Learn