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 ...

More details are emerging about in-memory capabilities in the new SQL Server 2014, announced at the recent TechEd 2013 conference. The first Community Technology Preview is expected to be released ...

When you decide to undertake your own benchmarking project, it’s a strongly recommended best practice to write up a benchmarking plan. For example, the dev architect might propose that the main OLTP ...

Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging ...

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 ...