News
SQL Server 2014’s biggest new feature is in-memory transaction processing, or in-memory OLTP, which Microsoft claims can make database operations as much as 30 times faster.
More details are emerging about in-memory capabilities and how they boost performance in the new SQL Server 2014, announced at the recent TechEd 2013 conference and possibly due for a CTP this month.
One of the most important differentiators amongst SQL Server 2014 and its earlier counterparts is in the former’s support for in-memory database tables. When our computer systems go slow we ...
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 ...
SQL Server 2016 is removing a lot of the limitations on memory-optimized tables including the inability to work with the large documents favored by NoSQL style designs.
SQL Server 2014 has the potential to make in-memory processing mainstream rather than only for specialist developers. You don't need to design tables in a different way to take advantage of in ...
SQL Server 2014 comes with diagnostic technologies that can examine the user’s databases and suggest the tables that should be moved to memory, based on how often they are consulted.
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.
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.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results