Free Inside Microsoft SQL Server 2008 T-SQL Querying (Developer Reference) Ebooks Online
Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance. Discover how to: Move from procedural programming to the language of sets and logic Optimize query tuning with a top-down methodology Assess algorithmic complexity to predict performance Compare data-aggregation techniques, including new grouping sets Manage data modification—insert, delete, update, merge—for performance Write more efficient queries against partitioned tables Work with graphs, trees, hierarchies, and recursive queries Plus—Use pure-logic puzzles to sharpen your problem-solving skills
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.4 pounds (View shipping rates and policies)
Average Customer Review: 4.5 out of 5 stars See all reviews (26 customer reviews)
Best Sellers Rank: #471,738 in Books (See Top 100 in Books) #76 in Books > Computers & Technology > Programming > Microsoft Programming > SQL Server #146 in Books > Computers & Technology > Programming > Microsoft Programming > .NET #158 in Books > Computers & Technology > Business Technology > Windows Server
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.
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.
Inside Microsoft SQL Server 2008 T-SQL Querying (Developer Reference) Inside Microsoft SQL Server 2008 T-SQL Programming (Developer Reference) MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 - Implementation and Maintenance: Microsoft SQL Server 2008--Implementation and Maintenance (Microsoft Press Training Kit) Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit) Microsoft Official Course 2778A Writing Queries Using Microsoft SQL Server 2008 Transact-SQL Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012 Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) Microsoft SQL Server 2008 Reporting Services Step by Step (Step by Step Developer) Microsoft SQL Server 2008 Step by Step (Step by Step Developer) The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset Learn SQL Server Administration in a Month of Lunches: Covers Microsoft SQL Server 2005-2014 Tabular Modeling in Microsoft SQL Server Analysis Services (2nd Edition) (Developer Reference) Microsoft SQL Server 2012 Integration Services (Developer Reference) Programming Microsoft SQL Server 2012 (Developer Reference) Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model (Developer Reference) Bundle: MCITP Guide to Microsoft Windows Server 2008, Server Administration, Exam #70-646 + Web-Based Labs Printed Access Cards Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 Microsoft SQL Server 2008 For Dummies (For Dummies (Computer/Tech)) Microsoft SQL Server 2008 Reporting Services
