SQL Server Internals: In-Memory OLTP: Inside the SQL Server 2016 Hekaton Engine
Language: English
Published by Red Gate Books, 2017
- Softcover
- Used
Seller: Goodwill Southern California, Los Angeles, CA, U.S.A.Goodwill Southern California
AbeBooks seller since December 20, 2017
Condition: Used - Good
US$ 22.20
Quantity: 1 available
Add to basketItem description from seller
Paperback Book.
Seller Inventory # LACV.1910035203.G
- Title
- SQL Server Internals: In-Memory OLTP: Inside the SQL Server 2016 Hekaton Engine
- Author
- Delaney, Kalen
- Publisher
- Red Gate Books
- Publication year
- 2017
- Condition
- good
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 1910035203
- ISBN 13
- 9781910035207
The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server has always provided.
Hekaton in-memory data is accessible, transparently, using familiar interfaces such as T-SQL and SSMS, but Hekaton's internal behavior and capabilities are very different than those of the standard relational engine. Everything you knew about how your SQL Server stores and accesses data is different in Hekaton. Everything you understood about how multiple concurrent processes are handled needs to be reconsidered.
In this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.
Kalen has been working with SQL Server since 1987, specializing in query performance tuning and SQL Server internals. The Hekaton internals knowledge she provides in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.
"Synopsis" may belong to another edition of this title.
Goodwill Southern California
Los Angeles, CA, U.S.A.
AbeBooks seller since December 20, 2017
Shipping rates within U.S.A.
| Item | 5 to 14 business days | 3 to 6 business days |
|---|---|---|
| First item | US$ 3.00 | US$ 6.50 |
Payment methods
Store description
Goodwill Southern California - We are a 501(c)(3) nonprofit organization whose mission is to help transform lives through the power of work. Goodwill Southern California serves individuals with disabilities or other vocational disadvantages and local businesses seeking qualified employees by providing education, skills training, work experience and job placement. In addition to our retail stores located throughout Southern California and in the Inland Empire, we also provide jobs and services such as secure shredding, e-recycling (computers and electronics), packaging and assembling, post retail recycling, etc. If you would like to know more about our company, our services, partnership opportunities or to make a donation, please either visit our website goodwillsocal.org, or contact us at our toll-free number, 1 (888) 4 GOODWILL. Thank you for your support of our mission to help others.…
Specialty
Used BooksSeller's business information
Goodwill Industries of Southern California
342 N San Fernando Rd
Los Angeles, CA U.S.A. 90031