best_bargain_books3 from NY, United States offers this stuff for:

Price : $22.99 Usually ships in 1-2 business days

booksandmore1 from GA, United States offers this stuff for:

Price : $23.00 Usually ships in 1-2 business days

--caiman-- from FL, United States offers this stuff for:

Price : $24.94 Usually ships in 1-2 business days

mckenziebooks from OR, United States offers this stuff for:

Price : $24.99 Usually ships in 1-2 business days

---greatbookdeals from FL, United States offers this stuff for:

Price : $26.52 Usually ships in 1-2 business days

sbd- from IN, United States offers this stuff for:

Price : $28.21 Usually ships in 1-2 business days

Amazon.com offers this stuff with condition New, new for:

Price : $29.69 Usually ships in 24 hours

bookrackrh from SC, United States offers this stuff for:

Price : $30.16 Usually ships in 1-2 business days

thermite-media from MD, United States offers this stuff for:

Price : $31.39 Usually ships in 1-2 business days

bargainbookstores- from MI, United States offers this stuff for:

Price : $31.40 Usually ships in 1-2 business days

What our customer's say!

"Fantastic in every way", As a programmer we go through many a book. And many of them read and feel like textbooks. So we skim, read in short bursts, simply would rather avoid the read.
This book is so well written that it can't be put down. And it's packed with REAL WORLD examples. Instead of just defining syntax and using a lame example, this book goes FAR beyond that, and digs deep into real world examples that really shine a light on your work.
I purchased this book almost a year ago, and it's still one of the most referenced books I have. I am constantly pulling it out when I reach a problem in my work, and this book always has great pointers to a solution.
This book will make you a T-SQL junkie, get it.

PS The logic puzzles in the back are great, too!

"Excellelent Intermediate or review", Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)

This is a great reference or review text. The content is fairly meaty and will take some chewing. For example, the book starts right off by breaking down the query engine process into it's processing steps and taking the reader through examples of the result sets at each step in the process. It might be overwhelming for someone starting out, but it's a great place to dive into a deeper understanding of the data engine.

"An excellent contribution to the "Inside-SQL" series", This is the 2nd book of the 4 part "Inside-SQL" series, with each book I imagine, appealing to a different reader. Having a programming background, I enjoyed this book more than the first in the series ("The Storage Engine"), which on it's own is also an excellent book.

As mentioned in other reviews, this book is definitely not for beginners. The authors assumes a basic level of SQL knowledge from the reader as he launches into complex Transact-SQL examples - unlike most books which start the reader with simple SQL examples and progress through to complex ones.

While reading this book, it was easy to compare it's contents with Ken Henderson's popular "A Guru's Guide to Transact-SQL", with the latter book becoming more and more outdated by the improvements in Transact-SQL since it was published. If you're a fan of Henderson, you will quickly become a fan of Itzik.

A benefit of this book is that unlike most SQL 2005 books, this is not an update on SQL 2000 material, but instead starts at the 2005 level. The author focuses on the new syntax introduced in SQL 2005, and then, moves onto older SQL 2000 syntax and compares both the complexity and the performance differences between the two. This itself is invaluable to those of use that code in Transact-SQL and feel more comfortable using the "old ways". This book highlights how the new syntax is in fact simpler and more efficient - we just need to take the time and effort to understand and become familiar with the new language changes.

The book starts by discussing the logical processing of a SELECT statement, which helps the reader to understand the hows and whys of writing a query. I finally understood why I can't use an expression's alias in a WHERE BY or GROUP BY clause (as the SELECT line is one of the last parts of the statement to be processed). Throughout the book, the author often defines a problem and allows the reader to formulate an appropriate solution. He then reveals MULTIPLE solutions and explains why each is good or bad. The book ends with a selection of "logic puzzles" that test the reader's ability to solve logical problems. This was both fun and informative.

After reading this book, I found myself changing the way I constructed SQL queries at work - for the better!

"Pedantic", The MS SQL books have dramatically risen in quality in a few short years. When SQL 7 and 2000 were released, there were may be 1-3 book which were truly outstanding. For SQL 2005, however, there are at least 5-10 books which are truly worthwhile and this is one of them.

The reason why the quality of books has risen is the expertise of the authors. For this book, the authors are either MS SQL MVP or have been involved with the creation of MS SQL at Microsoft.

Generally speaking, the book has high level expert description of the underlying MS SQL 2005 architecture and T-SQL commands. But it lacks a nice flowing writing style which hempers the understanding to a willing reader. This book is an another example of authors who are inept at explaining the subject matter which they are an expert much like a professor who can't teach.

I also felt some parts of the book were sloppy or not as detailed. For example, the authors state that one of the steps of T-SQL query tuning is the need to correlate wait stats with problematic queries. Yet they never provide an adequate example (other than providing a useless query of SYS.DM_OS_PERFORMANCE_COUNTERS table) of how to connect wait stat with a specific transaction. This is a huge missing link.

PROS:
1)Awesome details on Indexes and Query plans
2)Solid advice on how to improve T-SQL for better performance.

Cons:
1)Not for the beginners. The book goes straight to the harder subjects (PIVOT, APPLY, complex joins etc).
2)Does not cover simple or fundamental subject matters.





"Excellent", Normally I don't write a review but I liked this book enough to do so. I am a programmer not an SQL developer. I knew the basics but not the details and I had to write complex queries in SQL 2005 so I researched books for couple days before I bought this one. I have never heard of CTE, APPLY, ROW_NUMBER or PIVOT to mention few. This book at the beginning gives you the basics to understand how queries are processed internally, the difference between the types of indexes and how to read the execution plans. Then it dives into the language. Each example is well thought. The example goes over the syntax, performance and also optimization. I read all of it and did most of the examples.

Read this reviews before You buy...

"Abstract, Difficult, absolutely Gorgeous ", This book is so challenging and abstract that if it were not absolutely gorgeous it would have been gathering dust on my bookshelf by now. I am working a lot right now with accounting problems and have found chapter #9 on hierarchies to be very elegant and helpful. The knowledge density of this book reminds me of K&R or Harbinger and Steele in C programming. This is not a reference book, nor is it a "do" piece. It is a think piece and will, perhaps profoundly, improve your fundamental understanding of how databases and the SQL language work.

Having done a fair amount of embedded SQL programming in C, I always found that transition very difficult as the scales that the two languages work on and their approach to problems is so very different. Itzik articulates the nature of SQL programming, and thinking in that paradigm very precisely, and it was immediately clear what the issues were there. It helped characterize the thinking required for SQL and sets so clearly that it alone was worth the price of the book. This book should be thought of in the same vein as a data structures and algorithms book. You will pull it down off the shelf many times during design and planning phases to affirm your approach is sound and even optimal. This should be one of the ten books you take to a desert island.



"Amazing and Informative", There is an amazing wealth of knowledge contained in this book. The authors did a really great job of organizing the information, as well as providing examples that you can use to dive right in. As I've walked around my office and visited other database developers I've noticed this book on many desks along with his other book T-SQL Programming, which I will buy next.

"This is an outstanding book....", You don't always have the opportunity to learn from masters like Itzik Ben-Gan and the other co-authors...but you WILL learn from the T-SQL masters in this book!

This is an OUSTANDING BOOK and even though I've been acquainted with T-SQL for nearly four years I'm amazed at the insight and depth found in this book.

If there is any "ding" against this book it's that the book is not for absolute beginners...better have at least a clue before cracking these pages.

I also heartily recommend Itzik's T-SQL Programming book...buy these both at the same time!

"Well worth your valuable learning time", Well written, concise, clear, and fun all wrapped into one cover. One of the top books on T-SQL I have ever had the pleasure of reading.

"Excellent info but with complex style !", This book is having excellent information , but reading it is not fun , its complex , sometime's boring ! , author's writing style prefers complexity not simplicity approaching demonstration of problem solving and tuning examples, also he should reduce statements like `I will show you later' , `will give links at end of chapter' , `in other book will talk about this' , in this chapter will talk about so and so then give summary then give links then ,... and the like , just write and let the reader finds out the info when it arrives .

But still , it has an excellent info - IF - you can digest the meal !