Pro SQL Server Internals
Год: 2014
Автор: Dmitri Korotkevitch
Издательство: Apress
ISBN: 978-1-4302-5963-3
Серия: The Expert's Voice in SQL Server
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 776
Описание: Pro SQL Server Internals peels back the covers of SQL Server, explaining in detail how the database works in a way that allows you to immediately apply this knowledge to day-to-day tasks. It uncovers the product internals and, more importantly, demystifies how internal implementation affects your system. You'll learn how SQL Server stores its data and along with that, how to create efficient, fast, cost-effective indexes. You'll see why there is locking and how to troubleshoot and avoid concurrency issues. You'll discover how SQL Server implements various database object types and what their pros, cons and best use cases are. Knowledge of SQL Server internals is crucial when you want to get the most from the product. It helps to understand how various design and implementation decisions affect database behavior and performance as well as how to efficiently troubleshoot and pinpoint problems in existing systems. With Pro SQL Server Internals, you have your roadmap to understanding the depth and power of the SQL Server database. Pro SQL Server Internals: * Explains how to design efficient database schema, indexing and transaction strategies * Shows how various database object types are implemented internally * Demonstrates how SQL Server works with transaction logs What you'll learn * Design efficient database schema and indexing strategies * Understand pros, cons and best use-cases of the various database object types and technologies * Troubleshoot locking, blocking and performance issues in the systems * Design efficient transaction strategies * Get familiar with query life cycle and potential issues with plan cache and parameterization * Design efficient backup and high availability strategies Who this book is for Pro SQL Server Internals is a book for developers and database administrators who want to design, develop and maintain systems in a way that gets the most from SQL Server. This book is for professionals who wish to understand what happens 'under the hood' when a particular decision is made and how that affects the system. Pro SQL Server Internals is an excellent choice for people who prefer to understand and fix the root cause of the problem rather than applying a 'band aid' to it.
Примеры страниц Оглавление
About the Author xxiii
About the Technical Reviewers xxv
Acknowledgments xxvii
Introduction xxix
Part 1: Tables and Indexes 1
Chapter 1: Data Storage Internals 3
Chapter 2: Tables and Indexes: Internal Structure and Access Methods 29
Chapter 3: Statistics 53
Chapter 4: Special Indexing and Storage Features 81
Chapter 5: Index Fragmentation 113
Chapter 6: Designing and Tuning the Indexes 125
Part 2: Other things that matter 149
Chapter 7: Constraints 151
Chapter 8: Triggers 165
Chapter 9: Views 181
Chapter 10: User-Defined Functions 195
Chapter 11: XML 209
Chapter 12: Temporary Tables 233
Chapter 13: CLR 255
Chapter 14: CLR Types 275
Chapter 15: Data Partitioning 301
Chapter 16: System Design Considerations 349
Part 3: Locking, Blocking and Concurrency 373
Chapter 17: Lock Types 375
Chapter 18: Troubleshooting Blocking Issues 387
Chapter 19: Deadlocks 399
Chapter 20: Lock Escalation 417
Chapter 21: Optimistic Isolation Levels 427
Chapter 22: Application Locks 439
Chapter 23: Schema Locks 443
Chapter 24: Designing Transaction Strategies 455
Part 4: Query Life Cycle 459
Chapter 25: Query Optimization and Execution 461
Chapter 26: Plan Caching 489
Part 5: Practical Troubleshooting 521
Chapter 27: System Troubleshooting 523
Chapter 28: Extended Events 553
Part 6: Inside the transaction log 583
Chapter 29: Transaction Log Internals 585
Chapter 30: Designing a Backup Strategy 603
Chapter 31: Designing a High Availability Strategy 625
Part 7: In-Memory OLTP Engine 647
Chapter 32: In-Memory OLTP Internals 649
Part 8: Columnstore Indexes 689
Chapter 33: In-Memory OLTP Programmability 691
Chapter 34: Introduction to Columnstore Indexes 709
Chapter 35: Clustered Columnstore Indexes 737
Index 755
Опубликовано группой

If you like the topic, please click share to help develop our site.

To download the file disable ad blocking, and reload the page.

disable adblock How to disable ad blocking?

Download by magnet link 44 MB Download Torrent

Login using:

Current time is: 23-Apr 21:09 :: All times are UTC + 3