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

This whitepaper illustrates the SQL Server 2016 business intelligence/data warehouse upgrades, the memory-optimized tables, and the columnstore indexes. We also discuss the performance comparison of ...

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

SQL Server 2014 provides a comprehensive high-end database solution that can meet the emerging demands of the businesses and enterprises alike. It marks the release of Microsoft’s flagship database ...

Billed as “Microsoft’s cloud first data platform,” SQL Server 2014 will be released to manufacturing this week, with general availability scheduled for April 1, 2014. SQL Server 2014’s biggest new ...

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

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

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

As a consultant whose job description includes putting out performance fires, I get to see a lot of problematic queries that can dramatically harm overall server performance and throughput. Wondering ...

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