Microsoft SQL Server 2008 Internals (Pro - Developer) |  | Authors: Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic Publisher: Microsoft Press Category: Book
List Price: $59.99 Buy New: $32.85 as of 3/9/2010 21:47 CST details You Save: $27.14 (45%)
New (32) Used (12) from $32.78
Seller: best_bargain_books3 Rating: 9 reviews Sales Rank: 7117
Media: Paperback Edition: 1 Pages: 784 Number Of Items: 1 Shipping Weight (lbs): 3.2 Dimensions (in): 8.9 x 7.3 x 2
ISBN: 0735626243 Dewey Decimal Number: 005 EAN: 9780735626249 ASIN: 0735626243
Publication Date: March 11, 2009 Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including: - What happens internally when SQL Server builds, expands, shrinks, and moves databases
- How to use event tracking—from triggers to the Extended Events Engine
- Why the right indexes can drastically reduce your query execution time
- How to transcend normal row-size limits with new storage capabilities
- How the Query Optimizer operates
- Multiple techniques for troubleshooting problematic query plans
- When to force SQL Server to reuse a cached query plan—or create a new one
- What SQL Server checks internally when running DBCC
- How to choose among five isolation levels and two concurrency models when working with multiple concurrent users
|
| Customer Reviews:
Showing reviews 1-5 of 9
Great book February 27, 2010 Artem Naumov (Russia) Interesting, but some times for advanced sql server users and some times for beginners :)
Must have book February 21, 2010 B. Blahitka If you plan to do any SQL Server work, then this is must have book for you. Book has lot's of low level details. This book is an introduction to amazing world of SQL Server. It's great help while improving performance of you database. Easy to read, very usefull, brings real benefits during db development.
Great Book! February 15, 2010 Lenny B (Minneapolis, MN) Kalen Delaney has written another thorough reference that is a joy to possess for any senior DBA!
Love the book January 20, 2010 Valentin Malakhov 1 out of 1 found this review helpful
Amazing in-depth overview of SQL2008 with some exposure of 2005 and also 2000.
You would never find anything of this grade anywhere else.
It's a must for anyone who dares calling themselves a worthy MS SQL specialist, be it DBA, SQL programmer, DWH specialist, or a BI developer dealing with RDB.
AAA
The best reference on internals. Period. December 16, 2009 A. Bertrand (Rhode Island) 2 out of 2 found this review helpful
I started working with SQL Server in version 6.5, but it wasn't until several years later, when I had access to Kalen's "Inside SQL Server 2000" title, that I truly began to understand some of the core and fundamental concepts in how the engine works. She has continued this trend of providing books with more knowledge and examples than I can handle, but they have all helped me advance my understanding of SQL Server, and this in turn has paid huge dividends in several projects in my career. If you are going to get one SQL Server book to help you grasp the deep-down mechanics of SQL Server, this is the book you need.
Showing reviews 1-5 of 9
|
|
|