• Hi Gabriel,

    In this version of SQL server, the execution of T-SQL statements does not need require that many instructions to execute it. Also if you create compiled stored procs, it is created as DLL's and they are loaded up into memory at the time of initialization of the DB. You might also know that DLL's are faster since it is already compiled.

    -Roy