QUERY Execution in SQL Server 2005
SQL Server is made up to two components.Relational and Storage Engine.
1.Your query first given to PARSER.
2. PARSER create a parse tree for your query and sends to TSQL compiler.
3. T-SQL compiler will compile the query and if the query is compiled sucessfully , system sends it to optimizer.
4. Optimizer will then create the execution plan of the query and sends to executor.
5. Executor then dispatches the command. Execution plan gets into the memory.It then calls the pages from the physical memory and puts them in the RAM. After that these pages are given to relational engine.The relational engine then converts them into a tabular structure. After the conversion the result is given to the user.
Please correct me if i missed anything. We all are here to learn.