Home > Uncategorized > SQL Server 2012 SP1 and Hekaton

SQL Server 2012 SP1 and Hekaton


Big big announcements at SQL Pass. Firstly , SP1 is now available for SQL 2012. There seems to be the usual fixes , but there also seems to be a lot with regards to compatibility with Excel 2013 and SharePoint 2013 for BI. If you’re planning to roll out BI on the 2013 platform , you need SP1. More impressively …….

 

The Column Store ( xVelocity ) technology that we saw for Data Warehousing applications will be available for OLTP applications ( NOT in SP 1 just to be clear ). There is no release date but this is exciting. Those of you who have seen what Column Store can do for Data Warehousing know that its pretty significant.

What we now know is that ColumnStore for Data Warehouse applications will become writable in the next major release of SQL Server ( no more dropping indexes to load ). But the impact of having this technology for OLTP means that all database applications will benefit from it and get that massive performance boost. How big a boost ? Well , Hekaton apparently means 100 in Greek …… 🙂 🙂 🙂 🙂 🙂

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: