1 out of 1 rated this helpful - Rate this topic

Query Processing Architecture

SQL Server 2008 R2

SQL Server 2008

The Database Engine processes queries on a variety of data storage architectures such as local tables, partitioned tables, and tables distributed across multiple servers. The following topics cover how SQL Server processes queries and optimizes query reuse through execution plan caching.

In This Section

SQL Statement Processing: Contains topics about processing SELECT statements that reference local tables.
Stored Procedure and Trigger Execution: Describes executing stored procedures and triggers.
Execution Plan Caching and Reuse: Contains topics about caching and reusing query execution plans.
Parallel Query Processing: Contains topics about creating and executing parallel query execution plans.
Distributed Query Architecture: Describes executing queries on data that is distributed across multiple servers.
Query Processing Enhancements on Partitioned Tables and Indexes: Describes enhancements in SQL Server 2008 for executing queries on partitioned tables and indexes.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD