New for SQL Server 2016 is the ability to place a Columnstore Index on an In-Memory Table.

Other in-memory features mentioned by the Microsoft SQL Server team include "enhanced in-memory ColumnStore for data warehousing," which supports real-time analytics and "new enhanced query processing ...

SQL Server 2014, released Tuesday, delivers “breakthrough performance for applications in throughput and latency,” Quentin Clark president of the company’s data platform group, said in a blog.

A business I support recently purchased an add on to the pos software they use. It uses .net 3 and sql server express 2005.<BR><BR>Their support tech came out and installed some new hardware (not ...

In SQL Server 2014 there were a number of restrictions on memory-optimized tables: you couldn't alter their structure after they were created; many SQL operators weren't supported (Outer Joins, ...

Memory Optimized Tables promise significant performance gains, but tend to be difficult to work with. SQL Server 2016 reduces much of the pain by offering ALTER TABLE support.

Server:<BR>DL380 G5 dual dual core 2.33Ghz, 4GB RAM<BR>Win2K3 Std R2 SP1 x64<BR>SQL 2005 Std SP2 x64<BR><BR>This weekend the SQL box chewed through every last bit of memory available.

Hekaton, Microsoft's coming in-memory database engine, will be built into the next version of SQL Server. Meanwhile, SQL Server 2012 SP1 is now generally available.