Free Downloads
The Guru's Guide To SQL Server Architecture And Internals

Ken Henderson's first two Guru's Guides for Addison-Wesley have beenwidely praised by reviewers, and have sold extremely well. He has now writtena key reference to SQL Server which is much broader in scope than either ofthe first two, which will appeal to an even larger audience. The Guru's Guide toSQL Server Architecture is all about the internal pieces of SQL Server, the

Paperback: 1072 pages

Publisher: Addison-Wesley Professional (November 1, 2003)

Language: English

ISBN-10: 0201700476

ISBN-13: 978-0201700473

Product Dimensions: 7 x 2 x 9.1 inches

Shipping Weight: 3.4 pounds (View shipping rates and policies)

Average Customer Review: 4.3 out of 5 stars  See all reviews (28 customer reviews)

Best Sellers Rank: #1,247,912 in Books (See Top 100 in Books) #75 in Books > Computers & Technology > Databases & Big Data > Relational Databases #584 in Books > Computers & Technology > Databases & Big Data > SQL #1223 in Books > Textbooks > Computer Science > Database Storage & Design

Alas, this book was a VERY disappointing reading.Its one of the biggest sins is having a misleading title. "SQL Server Architecture and Internals" ? Forget it.The first whole third of the book is Win32 in a nutshell. It tells you about memory, processes, I/O and everything. But I already have my Richter dog-eared all right, I wouldn't need a reminder in a book on SQL Server.Then, about the SQL Server. Internals ? What a joke. The only internals that you would find are names of the DLLs where this or that SQL Server subsystem resides and a few hardcore debugger sessions to show you those DLLs actually get loaded. Uh-huh, thanks.Can you imagine a book on SQL Server internals which doesn't mention pages and/or extents ? In-depth description of different execution plans ? This is the one.What this book really is, is 20 chapters worth of overviews for more or less known SQL Server features. Average-to-good overviews of a less known features. Uhm, architecture, internals ? Nope - SQLXML, DTS, notification services, cursors, transactions. Take cursors - it says there are four types of cursors, you know, static, etc. and shows an SQL snippet for each. That's basically it. Take transactions - ACID, isolation levels and usage hints. Oh well, it could be worse...Difficult to say without reading other books by the same author (not that I have an urge any more), but it appears he has written a whole series of them. You find sentences like "In my other book..." all over the place. Just love it:[quote]I must confess that I was conflicted when I sat down to write this chapter.

SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) The Guru's Guide to SQL Server Architecture and Internals SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) Pro SQL Server 2012 BI Solutions (Expert's Voice in SQL Server) SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server) Beginning SQL Server 2008 Express for Developers: From Novice to Professional (Expert's Voice in SQL Server) Pro SQL Server 2008 Failover Clustering (Expert's Voice in SQL Server) Red Hat Enterprise Linux (RHEL) 7 Server Installation and Administration: Training Manual: Covering CentOS-7 Server, Cloud computing, Bind9 DNS Server and Fedora 23 Server Red Hat Enterprise Linux (RHEL) 6 Server Installation & Administration: Training Manual: Covering CentOS-6, OpenSUSE 11.3 Server, Mandriva Enterprise Server, and Fedora 14 Server Professional SQL Server 2008 Internals and Troubleshooting Microsoft SQL Server 2012 Internals (Developer Reference) SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) Expert T-SQL Window Functions in SQL Server Hands-on Study Guide for Exam 70-411: Administering Windows Server 2012 R2 (Exam 70-411, 70-411, Exam Ref 70-411, MCSA Windows Server 2012 R2, MCSE Windows Server 2012 R2) Windows® Internals: Including Windows Server 2008 and Windows Vista, Fifth Edition (Developer Reference) Microsoft Windows Internals (4th Edition): Microsoft Windows Server 2003, Windows XP, and Windows 2000 Android Security Internals: An In-Depth Guide to Android's Security Architecture Solaris Internals: Solaris 10 and OpenSolaris Kernel Architecture (2nd Edition) Windows Internals, Part 1: System architecture, processes, threads, memory management, and more (7th Edition)