 Trade In this Item for up to £13.05
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Microsoft SQL Server 2008 Internals (Pro - Developer) for an Amazon.co.uk gift card of up to £13.05, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
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
About the Author
Kalen Delaney is a Microsoft MVP who has worked with SQL Server since 1987. She's a subject-matter expert on Microsoft's official SQL Server courses and previously wrote Inside SQL Server (Microsoft Press). She lives in the Pacific Northwest.
Paul Randal and wife Kimberly L. Tripp are two of the most-sought-after SQL Server speakers in the world. A Microsoft MVP and Regional Director, Paul is also contributing editor to TechNet Magazine.
Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with SQL Server since 1990. She lectures for a variety of events including Microsoft Tech*Ed and is married to co-editor and SQL guru Paul Randal.
Conor Cunningham is principal architect of the SQL Server Core Engine Team at Microsoft.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
3 of 3 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
This is the first Internals book I've ever read, and after a couple of chapters I am finding it to be an incredible learning journey. I've read the chapters that I felt were my strongest ground, yet with almost every sentence I've learnt something new. It's certainly not for newcomers to the SQL Server scene, and it's certainly not a How To - but for anyone who wants to understand what goes on underneath the hood in SQL Server, this is it!
1 of 1 people found the following review helpful
Format:Paperback
If you want to know the internal workings of SQL Server 2008 then this book is definitely for you, it contains a great deal of information regarding the inner workings of SQL Server.
A lot of hard has obviously gone into making sure the details are accurate, and once you have read this book you might end up catching yourself going into far more depth explaining topics in it to others then is needed...
A lot of hard has obviously gone into making sure the details are accurate, and once you have read this book you might end up catching yourself going into far more depth explaining topics in it to others then is needed...
4 of 5 people found the following review helpful
Format:Paperback
If SQL Server held court, then the authors of this book would all be part of the inner sanctum. I would buy a book by any of these authors, just on their names, so finding them all in on publication is really a no-brainer.
Anyone wishing to learn more about how the SQL Server engine works, rather than just learning by rote how to do things, should read this book to gain insight into the reasons why/how you do things. As such this book is not really for absolute beginners, but if you are a quick learner you will soon be able to appreciate parts of this book. The book goes to levels often skipped over by other publications.
Despite having multiple talented authors and deep technical content I found the book to come across in a consistent and enjoyable style, anyone serious about SQL Server should have this on their bookshelves.
Anyone wishing to learn more about how the SQL Server engine works, rather than just learning by rote how to do things, should read this book to gain insight into the reasons why/how you do things. As such this book is not really for absolute beginners, but if you are a quick learner you will soon be able to appreciate parts of this book. The book goes to levels often skipped over by other publications.
Despite having multiple talented authors and deep technical content I found the book to come across in a consistent and enjoyable style, anyone serious about SQL Server should have this on their bookshelves.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
A Must Read for any SQL DBA.
This book is a treasure trove of good, useful information.
An excellent read, well laid out, extremely well written and a relatively easy to absorb format. Read more
An excellent read, well laid out, extremely well written and a relatively easy to absorb format. Read more
Published 18 months ago by L.Kammer
Hard core SQL Server stuff
Great book, giving more information that you could shake a stick at.
If you are falling in to the trap of wanting to know more about SQL Server then get this book, you will... Read more
If you are falling in to the trap of wanting to know more about SQL Server then get this book, you will... Read more
Published 20 months ago by A. Jones
Useful but obscure
A very useful book if you want to deep dive - as the name implies it isnt for everyone. Some highly obscure things in the book - and I have had my moneys worth from it.
Published 21 months ago by M. Sear
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Programming > Languages & Tools
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
