Inside Microsoft SQL Server 2008: T-SQL querying

by Ben-Gan, Itzik

Type Book

Rate 0.0 /5

Details

Files

Reviews

Download

Title Statements

Full title :Inside Microsoft SQL Server 2008 : T-SQL querying / Itzik Ben-Gan [and others].

Summary

Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and advanced techniques to optimize your code's performance. Discover how to: Move from procedural programming to the language of sets and logic Optimize query tuning with a top-down methodology Assess algorithmic complexity to predict performance Compare data-aggregation techniques, including new grouping sets Manage data modification--insert, delete, update, merge--for performance Write more efficient queries against partitioned tables Work with graphs, trees, hierarchies, and recursive queries Plus--Use pure-logic puzzles to sharpen your problem-solving skills.

Edition Statements

Publication Date:©2009.

Publication Statements

Publisher(s):Microsoft Press
Place of Publication:Redmond, Wash
Language:eng
Publication Date:©2009.

Notes

Includes index.

The Physical Object

Description:xxiv, 798 pages : : illustrations

Edition Identifiers

ISBN:9780735634763, 0735634769, 0735626030, 9780735626034
oclc:ocn827175269
LC Classification:QA76.73.S67
Dewey Decimal:005.7585

Intro -- Inside Microsoft® SQL Server® 2008: T-SQL Querying -- Acknowledgments -- Introduction -- Companion Content and Sample Database -- Find Additional Content Online -- Support for These Books -- 1. Logical Query Processing -- Sample Query Based on Customers/Orders Scenario -- Logical Query Processing Phase Details -- Step 1-J2: Apply ON Filter (Join Condition) -- Step 1-J3: Add Outer Rows -- Step 2: The WHERE Phase -- Step 3: The GROUP BY Phase -- Step 4: The HAVING Phase -- Step 5: The SELECT Phase -- Step 5-2: Apply the DISTINCT Clause -- Step 5-3: Apply the TOP Option -- Step 6: The Presentation ORDER BY Phase -- Further Aspects of Logical Query Processing -- PIVOT -- UNPIVOT -- OVER Clause -- Set Operators -- Conclusion -- 2. Set Theory and Predicate Logic -- Undefined Terms -- Equality, Identity, and Sameness -- Mathematical Conventions -- Numbers -- Context -- Alphabetical Order -- Functions, Parameters, and Variables -- Instructions and Algorithms -- Set Theory -- Set-Builder Notation -- Well-Definedness of Sets -- Domains of Discourse -- Domains and Modeling -- Faithfulness -- Russell's Paradox -- Ordered Pairs, Tuples, and Cartesian Products -- The Cartesian Product …