Microsoft SQL Server 2012 Internals by Kalen Delaney Bob Beauchemin Conor Cunningham Jonathan Kehayias Benjamin Nevarez & Paul S. Randal

Microsoft SQL Server 2012 Internals by Kalen Delaney Bob Beauchemin Conor Cunningham Jonathan Kehayias Benjamin Nevarez & Paul S. Randal

Author:Kalen Delaney, Bob Beauchemin, Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez & Paul S. Randal [Kalen Delaney, Bob Beauchemin, Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal]
Language: eng
Format: epub
Tags: COMPUTERS / Databases / Data Mining
ISBN: 9780735658554
Publisher: Microsoft Press
Published: 2013-11-19T16:00:00+00:00


Introducing query processing and execution

To better understand the factors that affect query performance, to understand how to spot potential performance problems with a query plan, and ultimately to learn how to use query optimizer hints to tune individual query plans, we first need to understand how the SQL Server query processor executes queries. This section introduces iterators, one of the most fundamental query execution concepts; discusses how to read and understand query plans; explores some of the most common query execution operators; and shows how SQL Server combines these operators to execute even the most complex queries.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.