Creating Memory-Optimized Database And Table

Posted Leave a commentPosted in Blog, Database, Technology

Hello All, I hope you read my previous blog In-Memory OLTP . This is my second blog in In-Memory OLTP Series. As of now, you should have known what Sql Server In-Memory OLTP is. Giving you a quick recap, this new feature of Sql Server allows you to store your data entirely in memory giving you up to 100 times performance benefit. In real time, you can expect up to 40 times performance improvement. The coolest of all is your application doesn’t require […]

SQL Server In-Memory OLTP

Posted Leave a commentPosted in Blog, Database, Technology

In my next few blogs, I would attempt to explain you about SQL Server’s In-Memory OLTP (Hekaton). Let me know how am I doing with it by giving your valuable comments. In-Memory OLTP is the new feature introduced with the latest version of Sql Server i.e SQL Server  2014. What is In-Memory Computing? Kirill Sheynkman describes In-Memory Computing as “In-Memory Computing is based on a memory-first principle utilizing high-performance, integrated, distributed main memory systems to compute and transact on large-scale data sets […]