Pro SQL Server Internals
Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work “under the hood,” and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and it...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2016.
|
| Edición: | 2nd ed. 2016. |
| Colección: | Expert's voice in SQL server.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631383706719 |
Tabla de Contenidos:
- Part 1: Tables and Indexes
- 1. Data Storage Internals
- 2. Tables and Indexes
- 3. Statistics
- 4. Special Indexing and Storage Features
- 5. SQL Server 2016 Enhancements
- 6. Index Fragmentation
- 7. Designing and Tuning the Indexes
- Part 2: Other Things That Matter
- 8. Constraints
- 9. Triggers
- 10. Views
- 11. Functions
- 12. XML and JSON
- 13. Temporary Tables and TempDB
- 14. CLR
- 15. CLR Types
- 16. Data Partitioning
- Part 3: Locking, Blocking and Concurrency
- 17. Lock Types and Transaction Isolation Levels
- 18. Troubleshooting Blocking Issues
- 19. Deadlocks
- 20. Lock Escalations
- 21. Optimistic Isolation Levels
- 22. Application Locks
- 23. Schema Locks
- 24. Designing Transaction Strategies
- Part 4: Query Life Cycle
- 25. Query Optimization and Execution
- 26. Plan Caching
- Part 5: Practical Troubleshooting
- 27. System Troubleshooting
- 28. Extended events
- 29. Query Store
- Part 6: Inside the Transaction Log
- 30. Transaction Log Internals
- 31. Backup and Restore
- 32. High Availability Technologies
- Part 7: In-Memory OLTP Engine
- 33. Column-Based Storage and Batch Mode Execution
- 34. Columnstore Indexes
- Part 8: In-Memory OLTP Engine
- 35. In-Memory OLTP Internals
- 36. Transaction Processing in In-Memory OLTP
- 37. In-Memory OLTP Programmability.
