Product 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 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

Product Details

• Amazon Sales Rank: #12117 in Books
• Published on: 2009-03-25
• Original language: English
• Number of items: 1
• Binding: Paperback
• 688 pages

Customer Reviews

What else can we ask to have in one book about T-SQL Querying?
I have really enjoyed this book from the begining to the end.

The new chapters from Steve and Dejan:

- Set Theory and Predicate Logic
- Algorithms and Complexity
- The Relational Model

are a very good complement. Having these topics is handy and refreshing, not to mention a must in this discipline.

Itzik's cover about the new T-SQL features introduced with SQL Server 2008, is insightful and very well guided. No doubt that he is an educator by nature.

If you are new to T-SQL, I strongly recommend that you first read Itzik's book "Microsoft® SQL Server® 2008 T-SQL Fundamentals", prior to diving into this series (T-SQL Querying and T-SQL Programming).

Thanks to all the authors for such wonderful book.

Alejandro Mesa
SQL Server MVP

Very well done
I'm new to T-SQL, but not new to database programming. I found this to be an excellent reference for the advanced programmer. The examples are well thought out and well organized. He often gives several different examples of how to solve a problem along with the pros and cons of each solution.

Great mentoring book
As usual books from Itzik Ben-Gan give me better understanding of hard-to-grasp concept related to set theory and SQL query.