Inside Microsoft® SQL Server® 2008: T-SQL Querying |  | Authors: Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass Publisher: Microsoft Press
List Price: $49.99 Buy New: $31.48 as of 11/21/2009 16:00 CST details You Save: $18.51 (37%)
New (23) Used (11) from $24.99
Seller: knowledgenmore Rating: 3 reviews Sales Rank: 13586
Media: Paperback Edition: 1 Pages: 688 Number Of Items: 1 Shipping Weight (lbs): 3.5 Dimensions (in): 8.9 x 7.3 x 2.1
ISBN: 0735626030 Dewey Decimal Number: 005.2768 EAN: 9780735626034 ASIN: 0735626030
Publication Date: March 25, 2009 Shipping: Eligible for FREE Super Saver Shipping Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| 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
|
| Customer Reviews: Very well done August 24, 2009 K. Goodhew (Boulder, CO USA) 1 out of 1 found this review helpful
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.
What else can we ask to have in one book about T-SQL Querying? July 19, 2009 Alejandro Mesa (Lake Wylie, SC USA) 2 out of 2 found this review helpful
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
Great mentoring book April 30, 2009 Maciej Kaski (Warsaw, Poland) 3 out of 5 found this review helpful
As usual books from Itzik Ben-Gan give me better understanding of hard-to-grasp concept related to set theory and SQL query.
|
|
|
|