Expert SQL Server in-Memory OLTP 1st Edition
Thumbnail 1Thumbnail 2

Expert SQL Server in-Memory OLTP 1st Edition

Product ID: 25752932
Secure Transaction
Frequently Bought Together

Description

Full description not available

Reviews

I**K

Highly recommend

Hi,I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.This book aims to explain SQL Server In-Memory OLTP, which can dramatically improve performance, how does it fare?In-Memory OLTP is the primary reason to migrate to SQL Server 2014. Under the right conditions it can offer significant performance benefits, with code typically running 20 to 40 times faster.This book is targeted at SQL Server developers and architects wanting to know how to take advantage of the potential performance improvements. Some background knowledge of SQL Server, especially performance, will be useful.This is a single topic book, having 11 chapters and 4 short appendices, contained within around 240 working pages.Below is a chapter-by-chapter exploration of the topics covered.Chapter 1 Why In-Memory OLTP?The chapter opens with a look at the background of In-Memory OLTP. Historically, memory was expensive, it made sense to store data on disks and bring it into memory for processing. With the advent of much cheaper memory, a different processing model could be used. In-Memory OLTP was designed for scalable fast processing. The design resulted in In-Memory structures, a concurrency model that eliminates locks and latches, and natively compiled stored procedures that use significantly fewer CPU cycles – all of which can significantly improve performance.Additionally, In-Memory OLTP is integrated seamlessly with other SQL Server 2014 components, there is no need for system refactoring – this is a major advantage when compared with other database vendors. There are some limitations, but you can expect these to reduce with future versions of SQL Server.The chapter continues with a look at In-Memory OLTP architecture. While In-Memory objects are fully integrated into SQL Server, and can be used transparently, internally they are different. The objects are stored in memory, they live outside the buffer pool, and have different structures compared with on-disk structures. Classic (i.e. interpreted) SQL can access In-Memory tables via interop, and this is typically 2 to 4 times faster than accessing the corresponding on-disk table. Natively compiled stored procedures can only access In-Memory tables, and are typically much faster than using interpreted SQL.This chapter provides a useful overview of how In-Memory OLTP arose, together with its major components.Useful discussions, diagrams, practical example code, website links, and inter-chapter links are given throughout. These traits apply to the whole of the book....ConclusionThis book has well-written discussions, helpful examples, diagrams, website links, inter-chapter links, and useful chapter summaries. It contains plenty of practical code to help you understand the subject matter.In-Memory OLTP is the primary reason to move to SQL Server 2014, it typically provides much faster processing. The book has a good flow between chapters, discussing what In-Memory OLTP is and how to implement it, culminating in a collection of impressive recommendations and best practices.Any criticisms I have are exceedingly minor. The book contains around 50% overlap with the author’s broader Pro SQL Server Internals book, see my review, which for me, that is the best SQL Server internals book I’ve read.If you want a practical discussion on In-Memory OLTP, including recommendations and best practices, I can highly recommend this erudite book.

Common Questions

Yes, all products are sourced directly from authorized retailers in the US, UK, UAE and India. We maintain strict quality control processes and verify each product before shipping. All items come with applicable manufacturer warranties and are covered by our standard return policy.
Delivery times vary by destination country, typically ranging from 3-9 business days. Each order is fully trackable through our system. We handle all customs clearance and use reliable courier partners for last-mile delivery. You'll receive regular updates about your order status via email and our app.
Desertcart is an international e-commerce platform operating since 2014. We securely process thousands of orders globally each day. Every product goes through our quality verification process before delivery, and we provide end-to-end order tracking, 24/7 customer support, and a comprehensive returns policy to ensure a safe shopping experience.
Our prices include the product cost, international shipping, import duties, customs clearance, and local delivery charges. We handle all customs and import procedures, ensuring there are no hidden fees upon delivery. PRO members receive additional benefits including free shipping.

Trustpilot

TrustScore 4.5 | 7,300+ reviews

Khalid Z.

Great experience from order to delivery. Highly recommended!

1 week ago

Pooja R.

The customer service exceeded my expectations. Perfect for buying products you can't find elsewhere.

1 week ago

Shop Global, Save with Desertcart
Value for Money
Competitive prices on a vast range of products
Shop Globally
Serving millions of shoppers across more than 100 countries
Enhanced Protection
Trusted payment options loved by worldwide shoppers
Customer Assurance
Trusted payment options loved by worldwide shoppers.
Desertcart App
Shop on the go, anytime, anywhere.
$46

Duties & taxes incl.

Dominicastore
1
Free Returns

30 daysfor PRO membership users

15 dayswithout membership

Secure Transaction

Ask AI about this Product

Trustpilot

TrustScore 4.5 | 7,300+ reviews

Ali H.

Fast shipping and excellent packaging. The Leatherman tool feels very premium and sturdy.

1 day ago

Vikram D.

The MOLLE sheath is of exceptional quality. Very happy with my purchase.

2 weeks ago

Expert Sql Server In Memory Oltp 1st Edition | Desertcart Dominica