SQL Server Internals: In-Memory Oltp: Inside the SQL Server 2016 Hekaton Engine

The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory...
€41,56 EUR
€41,56 EUR
SKU: 9781910035207
Product Type: Books
Please hurry! Only 558 left in stock
Author: Kalen Delaney
Format: Paperback
Language: English
Subtotal: €41,56
10 customers are viewing this product
SQL Server Internals: In-Memory Oltp: Inside the SQL Server 2016 Hekaton Engine by Delaney, Kalen

SQL Server Internals: In-Memory Oltp: Inside the SQL Server 2016 Hekaton Engine

€41,56

SQL Server Internals: In-Memory Oltp: Inside the SQL Server 2016 Hekaton Engine

€41,56
Author: Kalen Delaney
Format: Paperback
Language: English

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.



Author: Kalen Delaney
Publisher: Red Gate Books
Published: 10/16/2017
Pages: 204
Binding Type: Paperback
Weight: 0.79lbs
Size: 9.25h x 7.50w x 0.43d
ISBN: 9781910035207

This title is not returnable

Returns Policy

You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Related Products

Recently Viewed Products