Database Caching
SQL Server does not have a “results cache” and the second execution is not “practically free.”SQL Server does have a “buffer cache” and the second execution is “faster, but not free.” The SQL Server buffer cache holds data pages in memory, in the exact form that they reside on disk. The second execution will not have to perform... » read more