Query Processor Architecture

SQL statements are the only commands sent from applications to SQL Server 2005. All the work performed by an instance of SQL Server is the result of accepting, interpreting, and executing SQL statements. The processes by which SQL statements are executed by SQL Server include the following:

• Single SQL Statement Processing
• Stored Procedure and Trigger Execution
• Execution Plan Caching and Reuse
• Parallel Query Processing