Expert SQL Server In-Memory OLTP

Expert SQL Server In-Memory OLTP

Show other versions (1)

Take a deep dive into one of the most significant SQL Server features–support for In-Memory Online Transaction Processing. The latest developments are covered, including support of off-row storage, columnstore indexes and operational analytics, changes in programmability and native compilation, and...

Full description

Bibliographic Details
Main Author: Korotkevitch, Dmitri (Author)
Corporate Author: SpringerLink (Online service)
Format: Electronic eBook
Language:English
Published: Berkeley, CA : Apress : Imprint: Apress, 2017.
Edition:2nd ed.
Subjects:
Computer science.
Database management.
Computer Science.
Database Management.
Online Access:Full Text via HEAL-Link
Table of Contents:
  • Introduction.-.-1. Why In-Memory OLTP?
  • 2. In-Memory OLTP Objects
  • 3. Memory-Optimized Tables
  • 4. Hash Indexes
  • 5. Nonclustered Indexes
  • 6. Memory Consumers and Off-Row Storage
  • 7. Columnstore Indexes
  • 8. Transaction Processing in In-Memory OLTP
  • 9. In-Memory OLTP Programmability
  • 10. Data Storage, Checkpoint, and Recovery
  • 11. Garbage Collection
  • 12. Deployment and Management
  • 13. Utilizing In-Memory OLTP
  • 14. Appendix A: Memory Pointer Management
  • 15. Appendix B: Page Splitting and Page Merging in Nonclustered Indexes
  • 16. Appendix C: Analyzing the States of Checkpoint Files
  • 17. Appendix D: In-Memory OLTP Migration Tools.

Similar Items