MARC record from Internet Archive

LEADER: 02249cam a22002897a 4500
001 2009920791
003 DLC
005 20101015082433.0
008 090114s2009 waua 001 0 eng d
010 $a 2009920791
020 $a0735626030 (pbk.)
020 $a9780735626034
035 $a(OCoLC)ocn352905648
040 $aBNY$cBNY$dBWX$dOCLCQ$dALAUL$dDLC
042 $alccopycat
050 00 $aQA76.73.S67$bI57 2009
082 04 $a005.7585$222
245 00 $aInside Microsoft SQL Server 2008 :$bT-SQL querying /$cItzik Ben-Gan ... [et al.].
260 $aRedmond, Wash. :$bMicrosoft Press,$cc2009.
300 $axxiv, 798 p. :$bill. ;$c23 cm.
500 $aIncludes index.
505 0 $aChapter 1: Logical Query Processing -- Chapter 2: Set Theory and Predicate Logic -- Chapter 3: The Relational Model -- Chapter 4: Query Tuning -- Chapter 5: Algorithms and Complexity -- Chapter 6: Subqueries, Table Expressions and Ranking Functions -- Chapter 7: Joins and Set Operations -- Chapter 8: Aggregating and Pivoting Data -- Chapter 9: TOP and APPLY -- Chapter 10: Data Modification -- Chapter 11: Querying Partitioned Tables -- Chapter 12: Graphs, Trees, Hierarchies and Recursive Queries -- Appendix A: Logic Puzzles.
520 $aMaster the mechanics behind advanced querying and tuning - for faster, more scalable code. 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, and use pure-logic puzzles to sharpen your problem-solving skills.
630 00 $aSQL server.
650 0 $aClient/server computing.
650 0 $aRelational databases.
700 1 $aBen-Gan, Itzik.