Inside Microsoft SQL Server 2008: T-SQL Querying

E-Book Details

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

E-Book Summary

• Paperback: 832 pages
• Publisher: Microsoft Press; 1 edition (March 25, 2009)
• Language: English
• ISBN-10: 0735626030
• ISBN-13: 978-0735626034

Download Inside Microsoft SQL Server 2008: T-SQL Querying PDF Ebook

Related Posts

1. Inside Microsoft SQL Server 2008: T-SQL Programming
2. Microsoft SQL Server 2008 Internals
3. Microsoft SQL Server 2008 Administration For Oracle Dbas
4. Microsoft SQL Server 2008 Management And Administration
5. Microsoft SQL Server 2008 Administrator Pocket Consultant, 2Nd Edition
6. Microsoft Windows Server 2008 Administration
7. Microsoft Exchange Server 2010 Inside Out
8. Microsoft SQL Server 2008 R2 Unleashed
9. Microsoft SQL Server 2008 R2 Administration Cookbook
10. Beginning Microsoft SQL Server 2008 Administration