 | |  |
| Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) | 
| Authors: Itzik Ben-gan, Lubor Kollar, Dejan Sarka Publisher: Microsoft Press Category: Book
List Price: $44.99 Buy New: $26.47 You Save: $18.52 (41%)
Buy New/Used from $26.47
Avg. Customer Rating:   (29 reviews) Sales Rank: 14729
Languages: English (Original Language), English (Unknown), English (Published) Media: Paperback Number Of Items: 1 Pages: 632 Shipping Weight (lbs): 2.7 Dimensions (in): 8.8 x 6.9 x 1.6
ISBN: 0735623139 Dewey Decimal Number: 005.7565 EAN: 9780735623132 ASIN: 0735623139
Publication Date: April 26, 2006 Availability: Usually ships in 1-2 business days
|
| Customer Reviews:
| Showing reviews 26-29 of 29 | | « PREV | | |
  If you are only going to buy one SQL Server book... October 18, 2006 10 out of 12 found this review helpful
There are occassions when I like to believe that I can write really smart SQL queries. Then I see the stuff that Itzik Ben-Gan and Steve Kass (the Tecknial Rewiwer of this book) come up with, and I crawl back under my rock.
So if you want a book about advanced SQL Server querying and programming, there is little reason to search further. No one knows this topic better than Itzik. (As for T-SQL Programming there is a second book. Itzik and the publishers felt that it was too much for one book. So there are two. Querying is part one, Programming is part two.)
Of course you may ask: "OK, he knows the tecknical stuff, but is he a good author than can explain for the common man?". Being an SQL Server MVP myself, and thus considered an expert myself, this is somewhat difficult to assess. I do get the feeling in some places that he should explain a little more in depth. Not because I don't understand myself, I do. (Except in a few places where I just look and say "what?") But sometimes I suspect that more regular folks would benefit from more detailed explanations. Then again, this means that instead of reading the book once, you will have to read it twice.
Whatever, keep it as a reference. What is really valuable with the book is that you get cookbook recipes for problems that are not entirely trival to handle in SQL: Median, trees and graphs, custom aggregations etc. And you don't get one solution, you get a couple, since depending on the situation, different solutions work best. You will find, though, that you usually end up using the row_number() function. :-)
But as you may guess: this is not a book for beginners. If you are a habitual Oracle or DB2 programmer about to set your foot for the first time in SQL Server land, don't worry. This is the book for you. But if you are new to SQL programming, this is not the book for you, not yet.
  Learn to speak T-SQL from a master October 1, 2006 6 out of 6 found this review helpful
More so than any other language I can think of SQL is so approachable because it is so logical. Most people can grasp the basics within hours if not minutes. Unfortunately this approachability is often confused with simplicity. Learning SQL may be easy but becoming proficient takes time and guidance. Inside Microsoft SQL Server 2005: TSQL Querying, part 1 of the 2 part series (Inside Microsoft SQL Server 2005: TSQL Programming) is so much more than examples of what to do and what not to do. Itzik Ben-Gan takes you behind the editor and inside the engine to teach you the how's and why's. I recently had the good fortune to attend a course given by Itzik Ben-Gan who is a passionate instructor and a recognized expert. Whether it is listening to him speak, reading his articles in SQL Server magazine or reading this fantastic book there is no one more capable to help you hone your SQL skills.
  Best overview of SQL June 22, 2006 12 out of 14 found this review helpful
I was searching for a book that would fully cover both old and new (2005) features of T-SQL. This is the only one in the market that is actually doing so. But, more then that, the first chapter alone that explains how SQL works logically in human coherent language is worth the price of the whole book. And the other chapters are of same excelent quality. This is the best book about the subject in the market and I am sure to buy the sequel (about T-SQL programming.) ZA
  Far better than I anticipated - and I expected greatness! April 21, 2006 19 out of 24 found this review helpful
Having read Itzik Ben-Gan's articles in SQL Server Magazine for several years, I was expecting a well written and technically challenging book. All I can say now that I have been reading it is: "Wow!" It has really exceeded my expectations. I tire of the typical re-hash of the SQL Server Books Online that most authors are fond of doing lately, but this text digs far deeper and points out several items that can help any SQL Server professional build a more solid foundation in the art of T-SQL querying. I would highly recommend this book to anyone interested in a more thorough understanding of how SQL Server 2005 handles query processing.
|
|
| Powered by: Dknc, inc. and Amazon.com |  | 
For your safety and security, orders are processed through amazon.com
|
|
 |
|