Inside Microsoft® SQL ServerTM 2005 T-SQL Querying
Take a detailed look at the internal architecture of T-SQL-and unveil the power of set-based querying-with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627326206719 |
Tabla de Contenidos:
- Inside Microsoft® SQL ServerTM 2005 T-SQL Querying; Preface; Acknowledgments; Introduction; System Requirements; Installing Sample Databases; Updates; Code Samples; Support for This Book; 1. Logical Query Processing; Sample Query Based on Customers/Orders Scenario; Logical Query Processing Phase Details; Step 2: Applying the ON Filter (Join Condition); Step 3: Adding Outer Rows; Step 4: Applying the WHERE Filter; Step 5: Grouping; Step 6: Applying the CUBE or ROLLUP Option; Step 7: Applying the HAVING Filter; Step 8: Processing the SELECT List; Step 9: Applying the DISTINCT Clause
- Step 10: Applying the ORDER BY ClauseStep 11: Applying the TOP Option; New Logical Processing Phases in SQL Server 2005; PIVOT; UNPIVOT; OVER Clause; Set Operations; Conclusion; 2. Physical Query Processing; Compilation; Name Resolution; Type Derivation; Aggregate Binding; Grouping Binding; Optimization; Working with the Query Plan; XML Form of the Showplan; Graphical Showplan; Run-Time Information in Showplan; SET STATISTICS PROFILE; Capturing Showplan with SQL Trace; Extracting the Showplan from the Procedure Cache; Update Plans; Conclusion; 3. Query Tuning; Tuning Methodology
- Correlate Waits with QueuesDetermine Course of Action; Drill Down to the Database/File Level; Drill Down to the Process Level; Analyze Trace Data; Tune Indexes/Queries; Tools for Query Tuning; Clearing the Cache; Dynamic Management Objects; STATISTICS IO; Measuring the Run Time of Queries; Analyzing Execution Plans; Textual Showplans; XML Showplans; Hints; Traces/Profiler; Database Engine Tuning Advisor; Index Tuning; Heap; Clustered Index; Nonclustered Index on a Heap; Nonclustered Index on a Clustered Table; Index Access Methods; Unordered Covering Nonclustered Index Scan
- Ordered Clustered Index ScanOrdered Covering Nonclustered Index Scan; Nonclustered Index Seek + Ordered Partial Scan + Lookups; Unordered Nonclustered Index Scan + Lookups; Clustered Index Seek + Ordered Partial Scan; Covering Nonclustered Index Seek + Ordered Partial Scan; Index Intersection; Indexed Views; Index Optimization Scale; Unordered Covering Nonclustered Index Scan; Unordered Nonclustered Index Scan + Lookups; Nonclustered Index Seek + Ordered Partial Scan + Lookups; Clustered Index Seek + Ordered Partial Scan; Covering Nonclustered Index Seek + Ordered Partial Scan
- Index Optimization Scale Summary and AnalysisFragmentation; Partitioning; Preparing Sample Data; TABLESAMPLE; An Examination of Set-Based vs. Iterative/Procedural Approaches, and a Tuning Exercise; Additional Resources; Conclusion; 4. Subqueries, Table Expressions, and Ranking Functions; Correlated Subqueries; EXISTS; NOT EXISTS vs. NOT IN; Minimum Missing Value; Reverse Logic Applied to Relational Division Problems; Misbehaving Subqueries; Uncommon Predicates; Table Expressions; Using Arguments; Nesting; Multiple References; Common Table Expressions (CTE); Using Arguments; Multiple CTEs
- Multiple References
