Industrial-Sized Deals Shop all Back to School Shop Men's Hightops Learn more nav_sap_plcc_6M_fly_beacon David Ramirez $5 Off Fire TV Stick Subscribe & Save Shop Popular Services hog hog hog  Amazon Echo Starting at $99 Kindle Voyage Nintendo Digital Games Shop Now Deal of the Day
Inside Microsoft SQL Server 2008 T-SQL Querying and over one million other books are available for Amazon Kindle. Learn more

Inside Microsoft SQL Server 2008 T-SQL Querying (Developer Reference) 1st Edition

23 customer reviews
ISBN-13: 978-0735626034
ISBN-10: 0735626030
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
$19.59
Buy new
$49.99
More Buying Choices
18 New from $24.01 33 Used from $5.28

There is a newer edition of this item:

T-SQL Querying (Developer Reference)
$50.16
(8)
In stock but may require an extra 1-2 days to process.
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Rent Textbooks
$49.99 FREE Shipping. Only 8 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Inside Microsoft SQL Server 2008 T-SQL Querying (Developer Reference) + Inside Microsoft SQL Server 2008 T-SQL Programming (Developer Reference) + Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference)
Price for all three: $118.24

Buy the selected items together

Editorial Reviews

About the Author

Steve Kass, PhD, is an MVP for SQL Server and a professor of mathematics and computer science. He has written for SQL Server Magazine and spoken at SQL Server Magazine Connections events.

NO_CONTENT_IN_FEATURE


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Series: Developer Reference
  • Paperback: 832 pages
  • Publisher: Microsoft Press; 1 edition (April 4, 2009)
  • Language: English
  • ISBN-10: 0735626030
  • ISBN-13: 978-0735626034
  • Product Dimensions: 7.4 x 1.8 x 8.8 inches
  • Shipping Weight: 3.7 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (23 customer reviews)
  • Amazon Best Sellers Rank: #202,985 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

54 of 63 people found the following review helpful By Jose on February 27, 2010
Format: Paperback
I just went yesterday to a famous bookstore here in town to check this one before order it online and left a bit disappointed, with no desire at all to buy it. Don't get me wrong, Itzik is an awesome writer, a genius on his field, but I do not share the previous 5 start opinions and I will explain why.

I do not consider myself an TSQL expert but got some SQL DBA years on my belt and a MCTS cert too. Having said that and after almost finish reading Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer), same author, I found this one very difficult to follow, flooded with tons of theory and math that for a TSQL book is in my opinion too much. Yes, SQL language has strong logic and math background but that is not what DBAs or developers are looking on a technical book and this is not a college book either; people are looking for practical books which can be quickly be applied on daily job activities.

Chapter #2 for example is full of logic and math stuff that I honestly skipped immediately. Nice as bonus information but not "straight to the point" T-SQL stuff. You can easily take that chapter out and keep the book lighter in my honest opinion. Same for Chapter#3, more logic and math stuff, related to T-SQL, yes, but no the real stuff.

Chapter 1, 7 and 10 are taken of Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer), which by the way, is an outstanding book. Those chapters are about SELECT, JOINS and DML, information that like I said, can be found on the Fundamentals book but in an easy to read style, even with exercises so you can evaluate your own skills.

Chapter #4 is probably the more interesting chapter of the whole book, is about query performance.
Read more ›
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 9 people found the following review helpful By Alejandro Mesa on July 19, 2009
Format: Paperback Verified Purchase
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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Jaewoo Kim VINE VOICE on January 20, 2013
Format: Paperback Verified Purchase
Sometimes, the authors of technical books have the prerequisite expert knowledge and have an outstanding organization and game plan. But their writing is just too ambiguous. This is one of those books. The author should simply get to the point and not meander too much.

First, this book is not for the beginners. Indeed, you may not need all the knowledge contained in this book to be even intermediate DBA or DB Developer. But if you want to raise your knowledge of MS SQL to an expert level, a book like this sure helps. It is really too bad the author can't be more forthright in his writing.

Pros:
1)Expert in how MS SQL processes transactions.
2)Outstanding organization.
3)Comprehensive explanation of T-SQL.
4)If you want to understanding SQL performance tuning, this book is a must.

Cons:
1)Not for the beginners.
2)Writing could be far more lucid.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By R. R. Jacobsen on February 23, 2013
Format: Paperback Verified Purchase
In general, this book is well written and conveys the material in logical and progressive order. But readers should be ready for a great deal of theory. I read it quite a while ago and will still turn to it for tips that I remember being covered but that I now need to apply to a current problem -- the book delivers just what I need with sufficient examples to get rolling on my problem. When I read it, my background was pretty basic for T SQL but I did come away with a deeper appreciation for the product (SQL Server) and how to leverage it better in the future.

Regrettably, this book is written by multiple authors and it seemed easy for me to see the different styles of writing (good and bad) depending upon which section was being read. From my pov, a stronger editing for style would have helped because one author goes over the deep end covering theory while another seems to be able to cover theory sufficiently and then delivers a great hands-on and real world example showing how this theory matters.

There are some gems in the book to be sure. My favorites were:
The coverage of Set theory -- it is mathematics but really helped me understand how the product is built a particular way and how to leverage T SQL better with a well-built DB. This section was, from my pov, well written.

Learning about ROWNUMBER and HIERARCHYID. Boy can you use those in the real world! Never knew about them before reading this book.

How to optimize Indexes and usage of PIVOT.

Graphs, Trees, Hierarchies and Recursive Queries -- good material but delivered with too much theory and, imho, too little example.

Using CTE's (Common Table Expressions). I had never read about such things till this book and found it quite enlightening.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Inside Microsoft SQL Server 2008 T-SQL Querying (Developer Reference)
This item: Inside Microsoft SQL Server 2008 T-SQL Querying (Developer Reference)
Price: $49.99
Ships from and sold by Amazon.com

Want to discover more products? Check out these pages to see more: programming, windows server, sql server