Expert SQL Server In-Memory OLTP

• Κύριος συγγραφέας: Korotkevitch, Dmitri (Συγγραφέας)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2017.
• Έκδοση: 2nd ed.
• Θέματα: Computer science.; Database management.; Computer Science.; Database Management.

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...

Πίνακας περιεχομένων:

• 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.