Query Processor Architecture

SQL statements are the only commands sent from applications to Microsoft® SQL Server™. All of the work done by a copy of SQL Server is the result of accepting, interpreting, and executing SQL statements. These are the processes by which SQL statements are executed by SQL Server:

• Single SQL statement processing
• Batch processing
• Stored procedure and trigger execution
• Execution plan caching and reuse
• Parallel query processing