Series: Developer Reference
Paperback: 864 pages
Publisher: Microsoft Press; 1 edition (March 16, 2015)
Product Dimensions: 7.4 x 1.9 x 9 inches
Shipping Weight: 3.2 pounds (View shipping rates and policies)
Average Customer Review: 4.8 out of 5 stars See all reviews (20 customer reviews)
Best Sellers Rank: #122,180 in Books (See Top 100 in Books) #49 in Books > Computers & Technology > Databases & Big Data > SQL #116 in Books > Textbooks > Computer Science > Database Storage & Design #470 in Books > Textbooks > Computer Science > Programming Languages
Hi,I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.This book from SolidQ aims to give you a deeper understanding of T-SQL functionality. With an emphasis throughout on performance, how does it fare?This book is both an update to, and a combination of, three previous books (T-SQL Querying – published 2009, T-SQL Programming -2009, and T-SQL Using Window Functions - 2012). New material from SQL Server 2012 and 2014 is discussed, including: Window Functions, the new cardinality estimator, sequences, columnstore technology, and in-memory OLTP. It comes from SolidQ and is written by some of the most respected names in the world of SQ Server.Aimed primarily at developers and administrators, it offers a detailed view of internal architecture and a comprehensive programming reference. It aims to provide a practical approach together with techniques to optimize code. This is not a book for the beginner, it assumes at least one year's solid experience of T-SQL programming, and tuning basics.Below is a chapter-by-chapter exploration of the topics covered.Chapter 1 Logical query processingThis chapter opens with an observation about experts - they build their knowledge upon a solid understanding of the basics. So this chapter starts with a look at the basics, logical query processing i.e. the logical order the various parts of a T-SQL statement are executed. Each step is discussed in detail, these steps are:1. FROM phase (include virtual table for each of the possible types of join)2.
We've all been there: taking over a project from someone else only to wonder what they were doing as the code was poorly written.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 databaseAs 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.Pros:-This book is written to you, not at you!