FIGURE 1: Parse-and-Compile Results with Ad Hoc Caching

SQL Server parse and compile time: 
     CPU time = 11 ms, elapsed time = 20 ms.
----------- 
77

SQL Server parse and compile time: 
     CPU time = 10 ms, elapsed time = 10 ms.
----------- 
77

SQL Server parse and compile time: 
     CPU time = 0 ms, elapsed time = 0 ms.
----------- 
77