Hekaton

  • Comments posted to this topic are about the item Hekaton

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Nice and easy for the end of the week - thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • I love a question that should have a 100% success. It is a very nice way to get me to research new features.

    Thank you for the info, looking forward to this new feature.

  • nice question to end the week.

    ๐Ÿ™‚

    sql server 2014 seems to be very visionary.........

  • dogramone (10/3/2013)


    I love a question that should have a 100% success. It is a very nice way to get me to research new features.

    Thank you for the info, looking forward to this new feature.

    Good question...

  • Nice way to end the weekend. Good question.

  • This was removed by the editor as SPAM

  • Very very good question mascot. That was the only thing I knew about SQL 2014 so i shot it down quickly. ๐Ÿ™‚

    Thats the benefit we get on this platform. We have started getting familiar with the terminology even from the verison which is not yet in the market. Appreciate. ๐Ÿ™‚

  • Easy one thanks!

    (it's also the only useful new feature in SQL 2014 so far)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hekaton reminds me of old sci-fi movies. "Godzilla versus Hekaton".

  • OCTom (10/4/2013)


    Hekaton reminds me of old sci-fi movies. "Godzilla versus Hekaton".

    +1 Haha, that made me laugh this morning. Good question to end the week on; just so happened to be the only feature that I've read about so far.



    Everything is awesome!

  • Nice to see a QOTD that cannot be answered with "it depends".

    Tony
    ------------------------------------
    Are you suggesting coconuts migrate?

  • Nice question - and I think this is the first question we've had about hekaton.

    Koen Verbeeck (10/4/2013)


    Easy one thanks!

    (it's also the only useful new feature in SQL 2014 so far)

    Well, I think the ability to include indexes other that those which support constraints in the create table statement is useful; of course it would have been more useful if they'd done it properly and included filtered indexes and included columns in what could be done at create time. Also making secondary replicas usable for read-only workloads when the primary replica is down may reduce the pain of some otherwise very painful situations. The introduction of IMPERSONATE ANY LOGIN permission is a significant security improvement because it can be denied to high privilege users while still letting the do what they need to be able to do, and the buffer pool extension looks interesting for those who want better performance without going as far from disc storage as hekaton. The rest of what they've done to the Database Engine does look pretty boring (apart from the new hekaton data engine, of course); I haven't yet looked at anything but the data engine.

    Tom

  • L' Eomot Inversรฉ (10/4/2013)


    Nice question - and I think this is the first question we've had about hekaton.

    Koen Verbeeck (10/4/2013)


    Easy one thanks!

    (it's also the only useful new feature in SQL 2014 so far)

    Well, I think the ability to include indexes other that those which support constraints in the create table statement is useful; of course it would have been more useful if they'd done it properly and included filtered indexes and included columns in what could be done at create time. Also making secondary replicas usable for read-only workloads when the primary replica is down may reduce the pain of some otherwise very painful situations. The introduction of IMPERSONATE ANY LOGIN permission is a significant security improvement because it can be denied to high privilege users while still letting the do what they need to be able to do, and the buffer pool extension looks interesting for those who want better performance without going as far from disc storage as hekaton. The rest of what they've done to the Database Engine does look pretty boring (apart from the new hekaton data engine, of course); I haven't yet looked at anything but the data engine.

    I'd think the changes to columnstore indexes are also very useful.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • And I thought this was still under NDA... Thanks, mascot!

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply