Inside Microsoft SQL Server 2008: T-SQL Querying
(häftad)av Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
Bloggar
- Format:
- Häftad (paperback)
- Utgiven:
- 2009-03-01
- Språk:
- Engelska
Tackle the toughest set-based querying and query tuning problemsguided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internalsand gain practical approaches and advanced techniques to optimize your codes 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 modificationinsert, delete, update, mergefor performance
- Write more efficient queries against partitioned tables
- Work with graphs, trees, hierarchies, and recursive queries
- PlusUse pure-logic puzzles to sharpen your problem-solving skills
(Computer Bookshops Limited)
Passar bra ihop
|
De som köpt den här boken har ofta också köpt MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Im... av Mike Hotek | |||
|
Pris för båda:
597:-Köp
|
Fler böcker av författarna
|
|
|
|
|||
Microsoft SQL Server 2008 T-SQL FundamentalsItzik Ben-Gan (häftad) |
Inside Microsoft SQL Server 2008: T-SQL ProgrammingItzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah (häftad) |
MCTS Self-Paced Training Kit (Exam 70-448): Microsof...Erik Veerman, Teo Lachev, Dejan Sarka |
Advanced Transact-SQL for SQL Server 2000Itzik Ben-Gan, Tom Moreau (häftad) | |||
|
255:- Köp
|
255:- Köp
|
342:- Köp
|
742:- Köp
|
Kundrecensioner
Bli först med att recensera och betygsätt boken Inside Microsoft SQL Server 2008: T-SQL Querying -
du kan vinna 200 kr varje månad i tävlingen "Månadens recension".
Bloggat om Inside Microsoft SQL Server 2008: T-SQL Querying
Innehållsförteckning
ForewordAcknowledgmentsIntroductionChapter 1: Logical Query ProcessingChapter 2: Set Theory and Predicate LogicChapter 3: The Relational ModelChapter 4: Query TuningChapter 5: Algorithms and ComplexityChapter 6: Subqueries, Table Expressions, and Ranking FunctionsChapter 7: Joins and Set OperationsChapter 8: Aggregating and Pivoting DataChapter 9: TOP and APPLYChapter 10: Data ModificationChapter 11: Querying Partitioned TablesChapter 12: Graphs, Trees, Hierarchies, and Recursive QueriesAppendix A: Logic PuzzlesAbout the Authors
(Computer Bookshops Limited)
