Geek City: SQL Server 2014 In-Memory OLTP (“Hekaton”) Whitepaper for CTP2

Posted by Kalen Delaney on SQL Blog See other posts from SQL Blog or by Kalen Delaney
Published on Mon, 21 Oct 2013 00:05:00 GMT Indexed on 2013/10/21 4:03 UTC
Read the original article Hit count: 561

Filed under:

Hekaton

|

indexes

|

In-Memory OLTP

|

internals

|

Whitepapers

Last week at the PASS Summit in Charlotte, NC, the update of my whitepaper for CTP2 was released. The manager supervising the paper at Microsoft told me that David DeWitt himself said some very nice things about the technical quality of the paper, which was one of the most ego enhancing compliments I have ever gotten! Unfortunately, Dr. DeWitt said those things at his “After-the-keynote” session, not in the keynote that was recorded, so I only have my manager’s word for it. But I’ll take what I can...(read more)

© SQL Blog or respective owner

Related posts about Hekaton

Geek City: SQL Server 2014 In-Memory OLTP (“Hekaton”) Whitepaper for CTP2

as seen on SQL Blog - Search for 'SQL Blog'
Last week at the PASS Summit in Charlotte, NC, the update of my whitepaper for CTP2 was released. The manager supervising the paper at Microsoft told me that David DeWitt himself said some very nice things about the technical quality of the paper, which was one of the most ego enhancing compliments… >>> More
T-SQL Tuesday #33: Trick Shots: Undocumented, Underdocumented, and Unknown Conspiracies!

as seen on SQL Team - Search for 'SQL Team'
Mike Fal (b | t) is hosting this month's T-SQL Tuesday on Trick Shots. I love this choice because I've been preoccupied with sneaky/tricky/evil SQL Server stuff for a long time and have been presenting on it for the past year. Mike's directives were "Show us a cool trick or process you developed…It… >>> More
Hekaton – SQL Server’s in-memory database engine

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Microsoft have just gone public at the PASS Summit in Seattle about a new SQL Server engine that they’re working on which is optimized for high-memory servers – an in-memory OLTP database engine which is built-in to SQL Server rather than a separate entity. This means that you can move just… >>> More
SQLBeat Podcast – Episode 7 – Niko Neugebauer, Linguist, SQL MVP and Hekaton Lover

as seen on Simple Talk - Search for 'Simple Talk'
In this episode of the SQLBeat Podcast I steal Niko Neugebaur away from his guarded post at the PASS Community Zone at Summit 2012 in Seattle to chat with me about several intriguing topics. Mainly we discuss Hekaton and in memory databases, languages of all sorts, Microsoft’s direction, Reporting… >>> More
Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1

as seen on Simple Talk - Search for 'Simple Talk'
The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you to migrate the most-used tables in an existing database to memory-optimised 'Hekaton' technology, but how you balance between disk tables and in-memory tables for optimum performance… >>> More

Related posts about indexes

Stairway to SQL Server Indexes: Step 1, Introduction to Indexes

as seen on SQL Server Central - Search for 'SQL Server Central'
Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity… >>> More
When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes

as seen on SQL Server Central - Search for 'SQL Server Central'
SQL Server Clustered indexes can have enormous implications for performance of operations on a table. But are there times when a SQL Server non-clustered index would perform better than a clustered index for the same operation? Are there any trade-offs to consider? Check out this tip to learn more… >>> More
text indexes vs integer indexes in mysql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I have always tried to have an integer primary key on a table no matter what. But now I am questioning if this is always necessary. Let's say I have a product table and each product has a globally unique SKU number - that would be a string of say 8-16 characters. Why not make this the PK… >>> More
SQL SERVER – Disabled Index and Update Statistics

as seen on SQL Authority - Search for 'SQL Authority'
When we try to update the statistics, it throws an error as if the clustered index is disabled. Now let us enable the clustered index only and attempt to update the statistics of the table right after that. Have you ever come across the situation where a conversation never gets over and it continues… >>> More
Macro doesn't work in the function.

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problems with following code: http://lisper.ru/apps/format/96 The problem is in "normalize" function, which does not work. It fails on the fifth line: (zero-p a indexes i) (defun normalize (a &optional indexes i) "Returns normalized A." (pragma (format t "Data=~A ~A ~A" a indexes… >>> More