Eeeeeek it’s SQL2014 on windows 8.1

Finally time to install the new microsoft toys! Yeeh! Time to install virtual box and the freshly released windows 8.1 and install sql2014.

Get some code here and start a Hekaton

Memory optimalization code named Hekaton:

So we have this idea that our data belongs on disks and the data we need will be loaded into the memory of your machine for manipulation. In Hekaton transactions never get rolled back. when you change data, you create a new version in memory. If the transaction fails, the changes are never written to the disk. When a transaction does commit, it goes into the transaction log and a background process copies it back to the set of sequential files, the Hekaton data. These files are read at database start-up, when they get copied into memory. the downsite is, it has to fit in your RAM, if not, the new rows can't be added, you can't change it to the old write to disk mode. So, your old database probably will not work with hackaton, but Microsoft is working on a solution for this to optimize al your data.

to be continued...

25-6-2013 14-22-01

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.