- Series: Developer Reference
- Paperback: 864 pages
- Publisher: Microsoft Press; 1 edition (March 16, 2015)
- Language: English
- ISBN-10: 0735685045
- ISBN-13: 978-0735685048
- Product Dimensions: 7.3 x 1.9 x 9 inches
- Shipping Weight: 3.2 pounds (View shipping rates and policies)
- Average Customer Review: 27 customer reviews
- Amazon Best Sellers Rank: #57,852 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.
T-SQL Querying (Developer Reference) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently bought together
Customers who bought this item also bought
About the Author
Itzik Ben-Gan is a mentor for and co-founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik has authored several T-SQL books as well as articles for SQL Server Pro, SolidQ Journal, and MSDN. Itzik’s speaking activities include TechEd, SQLPASS, SQL Server Connections, SolidQ events, and various user groups around the world. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming and Tuning, and T-SQL Fundamentals courses, along with being a primary resource within the company for its T-SQL-related activities.
Dejan Sarka, MCT and SQL Server MVP, is an independent consultant, trainer, and developer focusing on database and business intelligence applications. His specialties are advanced topics like data modeling, data mining, and data quality. On these tough topics, he works and researches together with SolidQ and the Data Quality Institute. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of 11 books about databases and SQL Server, with more to come. He also has developed and is continuing to develop many courses and seminars for SolidQ and Microsoft. He has been a regular speaker at many conferences worldwide for more than 15 years, including Microsoft TechEd, PASS Summit, and others.
Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has contributed to several books on SQL Server, including T-SQL Querying (Microsoft Press, 2015) and SQL Server 2008 Internals (Microsoft Press, 2009). He regularly speaks at international conferences and training events on a variety of SQL Server topics.
Kevin Farlee has over 25 years in the industry, in both database and storage-management software. In his current role as a Storage Engine Program Manager on the Microsoft SQL Server team, he brings these threads together. His current projects include the SQL Server Project “Hekaton” In-Memory OLTP feature.
Try the Kindle edition and experience these great reading features:
27 customer reviews
Review this product
Showing 1-8 of 27 reviews
There was a problem filtering reviews right now. Please try again later.
This book is packed with excellent expert knowledge to help you grow your skills and think and design solutions for solving business problems.
This book is going to make realize YOU are also writing bad code.
Not intentionally, of course, but Ben-Gan really puts emphasis on performance and analyzing queries to show there's a better way to do a query, as most of the examples are what we see and write every day.
He doesn't just give a single code and say "Do it this way from now on." Instead, he talks to you as a professional and shows you the differences between doing the same query multiple ways.
Most of us think we understand how SQL works, but I can attest, both from my own ignorance and others' viewpoints, we really don't. Ben-Gan has been with SQL for many years, both in development of the database structure and how to write queries to take advantage of those changes.
The logical processing chapter, which is important given it's the first chapter, should open the eyes of many SQL code writers out there. This knowledge alone will have you rethinking SQL code as the chapters progress (and he quizzes you on some basic queries to try and guess the outcome, only to show why our thinking isn't taking advantage of SQL at all).
Like many, I learned SQL on previous versions, not really giving much thought to the actual database design as I simply use "new code features" introduced with the new database
As a recommendation, knowing how SQL works under the hood is just as important as knowing if a CTE is a better use than a temp table.
We always want to learn and improve, and this book is definitely a first step to doing both at the same time.
-This book is written to you, not at you! A refreshing take on making the information more personal, rather than instructional.
-Many examples, with analysis, to describe why queries do what they do, and how to avoid pitfalls of "old thinking"!!!
-Concise and to the point. No page is wasted with fillers to pad page counts!
-You'll most likely recommend this book after you read it, which is good, because it'll help with less "bad code" out there, even our own! ;)
Cons (though, take this as cautions, not bad things):
-This is NOT a reference book! This is a cover-to-cover read. It's unlikely this will be used often, aside from quick refreshes from time-to-time.
-Pricey, but only because many chapters may not pertain to readers who don't have SQL 2012/14. There's an older version out there, but I still recommend this one because the window feature (new for 2012+) is worth learning even if you can't use it yet.
That's about it. Thanks for reading and I hope this helps.