Korotkevitch, Dmitri
Pro SQL Server Internals
Part I. Tables and Indexes
1. Data Storage Internals
Dmitri Korotkevitch
2. Tables and Indexes: Internal Structure and Access Methods
Dmitri Korotkevitch
3. Statistics
Dmitri Korotkevitch
4. Special Indexing and Storage Features
Dmitri Korotkevitch
5. SQL Server 2016 Features
Dmitri Korotkevitch
6. Index Fragmentation
Dmitri Korotkevitch
7. Designing and Tuning the Indexes
Dmitri Korotkevitch
Part II. Other Things That Matter
8. Constraints
Dmitri Korotkevitch
9. Triggers
Dmitri Korotkevitch
10. Views
Dmitri Korotkevitch
11. User-Defined Functions
Dmitri Korotkevitch
12. XML and JSON
Dmitri Korotkevitch
13. Temporary Objects and TempDB
Dmitri Korotkevitch
14. CLR
Dmitri Korotkevitch
15. CLR Types
Dmitri Korotkevitch
16. Data Partitioning
Dmitri Korotkevitch
Part III. Locking, Blocking, and Concurrency
17. Lock Types and Transaction Isolation Levels
Dmitri Korotkevitch
18. Troubleshooting Blocking Issues
Dmitri Korotkevitch
19. Deadlocks
Dmitri Korotkevitch
20. Lock Escalation
Dmitri Korotkevitch
21. Optimistic Isolation Levels
Dmitri Korotkevitch
22. Application Locks
Dmitri Korotkevitch
23. Schema Locks
Dmitri Korotkevitch
24. Designing Transaction Strategies
Dmitri Korotkevitch
Part IV. Query Life Cycle
25. Query Optimization and Execution
Dmitri Korotkevitch
26. Plan Caching
Dmitri Korotkevitch
Part V. Practical Troubleshooting
27. Extended Events
Dmitri Korotkevitch
28. System Troubleshooting
Dmitri Korotkevitch
29. Query Store
Dmitri Korotkevitch
Part VI. Inside the Transaction Log
30. Transaction Log Internals
Dmitri Korotkevitch
31. Backup and Restore
Dmitri Korotkevitch
32. High Availability Technologies
Dmitri Korotkevitch
Part VII. Columnstore Indexes
33. Column-Based Storage and Batch Mode Execution
Dmitri Korotkevitch
34. Columnstore Indexes
Dmitri Korotkevitch
Part VIII. In-Memory OLTP Engine
35. In-Memory OLTP Internals
Dmitri Korotkevitch
36. Transaction Processing in In-Memory OLTP
Dmitri Korotkevitch
37. In-Memory OLTP Programmability
Dmitri Korotkevitch
Nyckelord: Computer Science, Database Management
- Författare
- Korotkevitch, Dmitri
- Utgivare
- Springer
- Utgivningsår
- 2016
- Språk
- en
- Utgåva
- 2nd ed.
- Sidantal
- 31 sidor
- Kategori
- Datateknik, Datakommunikation
- Format
- E-bok
- eISBN (PDF)
- 9781484219645
- Tryckt ISBN
- 978-1-4842-1963-8