Inside Microsoft® SQL Server® 2008: T-SQL Querying (Paperback)

~ (Author), (Author), (Author), Steve Kass (Author)
Key Phrases: table expressions, ranking functions, data modification, Inner Join, Nested Loops, Estimated Number of Rows (more...)

Editorial Reviews

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

• Paperback: 688 pages
• Publisher: Microsoft Press; 1 edition (March 25, 2009)
• Language: English
• ISBN-10: 0735626030
• ISBN-13: 978-0735626034
• Product Dimensions: 8.9 x 7.3 x 2.1 inches
• Shipping Weight: 3.5 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #21,127 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #8 in	Books > Computers & Internet > Microsoft > Development > SQL Server
  #13 in	Books > Computers & Internet > Networking > Data in the Enterprise > Client-Server Systems
  #14 in	Books > Computers & Internet > Databases > Database Management Systems

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

5.0 out of 5 stars What else can we ask to have in one book about T-SQL Querying?, July 19, 2009

By	Alejandro Mesa (Lake Wylie, SC USA) - See all my reviews (REAL NAME)

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

1 of 1 people found the following review helpful:

5.0 out of 5 stars Very well done, August 23, 2009

By	K. Goodhew (Boulder, CO USA) - See all my reviews (REAL NAME)

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.

3 of 5 people found the following review helpful:

5.0 out of 5 stars Great mentoring book, April 30, 2009

By	Maciej Kaski "maciek kanski" (Warsaw, Poland) - See all my reviews (REAL NAME)

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