Pro SQL Server Internals /
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Formato: | eBook |
| Lenguaje: | English |
| Publicado: |
Berkeley, CA :
Apress : Imprint: Apress,
2016.
|
| Edición: | 2nd ed. 2016. |
| Materias: |
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.