- Series: Developer Reference
- Paperback: 688 pages
- Publisher: Microsoft Press; 1 edition (March 25, 2009)
- Language: English
- ISBN-10: 0735626030
- ISBN-13: 978-0735626034
- Product Dimensions: 7.5 x 2 x 9 inches
- Shipping Weight: 3.4 pounds
- Average Customer Review: 27 customer reviews
- Amazon Best Sellers Rank: #1,061,584 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Inside Microsoft® SQL Server® 2008: T-SQL Querying (Developer Reference) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
See the Best Books of 2018 So Far
Looking for something great to read? Browse our editors' picks for the best books of the year so far in fiction, nonfiction, mysteries, children's books, and much more.
Customers who bought this item also bought
Customers who viewed this item also viewed
About the Author
Itzik Ben-Gan is a principal mentor and a founder of SolidQ. A Microsoft MVP for SQL Server since 1999, Itzik teaches and consults internationally on T-SQL querying, programming, and query tuning. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.
Lubor Kollar is group program manager with the SQL Server Customer Advisory Team at Microsoft, working on the most challenging SQL Server deployments worldwide. He has 13+ years of experience with SQL Server development.
Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
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.
1)Expert in how MS SQL processes transactions.
3)Comprehensive explanation of T-SQL.
4)If you want to understanding SQL performance tuning, this book is a must.
1)Not for the beginners.
2)Writing could be far more lucid.
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.
Query optimization -- what a great write up as to how SQL Server works when performing queries/searches followed by some great hands-on examples applying the theory.
This book remains one of my best references. I would recommend it to someone that has already had some T SQL experience and wants to take a deeper dive at optimizing their use of T SQL.
This book is a jewel. It gives complex and useful SQL algorythms along with explanation both on logic side and on performance side. The performance part will depend on whether you use SQL 2008, 2012, or even Oracle databases but the logical will remain forever on your mind.
If you have any doubts on joins, correlated subqueries, running aggregations, this book is the best that you can try to solve them. Itzik knows what he talks and he knows how to teach it. Thinking in a join in steps is so much easier and that is how Itzik teaches us to do.
Well, I am an Oracle DBA, but there is no book like this in my side, so I congratulate Microsoft Press for this one.