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

• We started tracking this book on April 18, 2014.
• This book was $38.23 when we started tracking it.
• The price of this book has changed 84 times in the past 4,187 days.
• The current price of this book is $35.99 last checked one year ago.
• This book is at its lowest price in the past year.
• The lowest price to date was $26.67 last reached on October 22, 2021.
• This book has been $26.67 6 times since we started tracking it.
• The highest price to date was $47.99 last reached on June 4, 2023.
• This book has been $47.99 19 times since we started tracking it.

• Computers & Technology

• Publication Date: March 11, 2009
• Text-to-Speech: Enabled
• Lending: Disabled
• Print Length: 1,557 Pages
• File Size: 6,281 KB