Microsoft has announced that the next version of SQL server will have the capability to run entire databases in-memory, offering massive performance increases, the company says.
The technology is code-named codenamed Hekaton, and already has several users, according to this article by InfoWorld. Microsoft says SQL transactions running in-memory will be as much as 50 times faster than using the platform on disk-based hardware.
Microsoft is joining a number of other major vendors, including SAP
AG and SAS
Institute Inc., which have sought to speed up database queries as well as analytics performed on unstructured data by storing it directly in RAM.