• Free shipping
  • More than one million students ordered here

Inside Microsoft SQL Server 2008 T-SQL Querying

ebook

9780735638303 - Inside Microsoft SQL Server 2008 T-SQL Querying
Secondhand

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 i
License duration Read ebook online: 730 days
Read ebook offline: perpetual
Can't be ordered

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 i
License duration Read ebook online: 730 days
Read ebook offline: perpetual