Expert SQL Server in-memory OLTP. (2015)

• Record Type: Book
• Further Information: Note: Dmitri Korotkevitch.
• Authors: Korotkevitch, Dmitri
• Contents: At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Why In-Memory OLTP?; Background; In-Memory OLTP Engine Architecture; Summary; Chapter 2: In-Memory OLTP Objects; Preparing a Database to Use In-Memory OLTP; Creating Memory-Optimized Tables; Working with Memory-Optimized Tables; In-Memory OLTP in Action: Resolving Latch Contention; Summary; Chapter 3: Memory-Optimized Tables; On-Disk vs. Memory-Optimized Tables; Introduction to the Multiversion Concurrency Control; Data Row Format. Native Compilation of Memory-Optimized Tables Memory-Optimized Tables: Surface Area and Limitations; Supported Data Types; Constraints and Table Features; Database-Level Limitations; High Availability Technologies Support; Summary; Chapter 4: Hash Indexes; Hashing Overview; Much Ado About Bucket Count; Bucket Count and Performance; Choosing the Right Bucket Count; Changing the Bucket Count in the Index; Hash Indexes and SARGability; Statistics on Memory-Optimized Tables; Summary; Chapter 5: Nonclustered Indexes; Working with Nonclustered Indexes; Creating Nonclustered Indexes. Using Nonclustered Indexes Nonclustered Indexes Internals; Bw-Tree Overview; Index Pages and Delta Records; Obtaining Information About Nonclustered Indexes; Hash Indexes vs. Nonclustered Indexes; Summary; Chapter 6: In-Memory OLTP Programmability; Native Compilation; Natively Compiled Stored Procedures; Creating Natively Compiled Stored Procedures; Supported T-SQL Features; Control Flow; Query Surface Area; Operators; Build-In Functions; Atomic Blocks; Optimization of Natively Compiled Stored Procedures; Interpreted T-SQL and Memory-Optimized Tables; Performance Comparison. Memory-Optimized Table Types and Variables Summary; Chapter 7: Transaction Processing in In-Memory OLTP; ACID, Transaction Isolation Levels, and Concurrency Phenomena Overview; Transaction Isolation Levels in In-Memory OLTP; Cross-Container Transactions; Transaction Lifetime; Summary; Chapter 8: Data Storage, Logging, and Recovery; Data Storage; Checkpoint File Pairs States; PRECREATED CFP State; UNDER CONSTRUCTION CFP State and CHECKPOINT Process; ACTIVE CFP State; MERGE TARGET and MERGED SOURCE CFP States and Merge Process.
• Publisher Details: Berkeley, CA : Apress
• Publication Date: 2015
• Copyright Date: 2015
• Extent: 1 online resource (225 pages)
• Subjects: 005.75/85; Computer science; Database management; COMPUTERS -- Databases -- Servers; Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484211366; 1484211367; 1484211375; 9781484211373
• Related ISBNs: 9781484211373
• Notes: Note: Online resource; title from PDF title page (SpringerLink, viewed September 24, 2015).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.