Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...

Last year, Microsoft officials said the next version of its SQL Server database would include built-in in-memory online transaction processing (OLTP) technology. That was all they'd say at that point ...

New in-memory online transaction processing (OLTP) improvements highlight the new features in the latest Community Technology Preview (CTP) of SQL Server 2016, the flagship RDBMS from Microsoft. SQL ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

The SQL Server in-memory solutions lead to dramatic improvements in performance, providing faster transactions, faster queries, and faster insights—all on a proven data platform architecture. This ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Online transaction processing systems are purpose-built to handle large numbers of transactions by large numbers of concurrent users, while guaranteeing the integrity of the data. Online transaction ...