Inside Microsoft SQL Server 2008 T-SQL Querying
Article description
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 as 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
Specifications
| ISBN/EAN | 9780735638303 |
| Type | ebook |
| License duration |
Read ebook online: 730 days
Read ebook offline: perpetual |
Article description
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 as 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
Specifications
| ISBN/EAN | 9780735638303 |
| Type | ebook |
| License duration |
Read ebook online: 730 days
Read ebook offline: perpetual |