Wednesday, June 21, 2017

In-Memory OLTP in Azure SQL Database

Hey guys, good news for you all who use Azure SQL Database.

Below are some of the cool features Microsoft added in Azure SQL Database:

  • Earlier including the index created with the primary key, the memory-optimized table can have up to 8 indexes only. Now with the changes incorporated in June 2017 we can create more than eight indexes on memory-optimized tables
  • No more alter table command to change the memory-optimized objects, sp_rename can be used for renaming memory-optimized objects
  • You will no longer see the Error 41839 – “Transaction exceeded the maximum number of commit dependencies and the last statement was aborted. Retry the statement.” Microsoft eliminated the limit on the number of commit dependencies
  • Now we are free to use the CASE expression, the CROSS APPLY operator, and all JSON functions, isn't it interesting!
  • Did you even think of using computed columns in memory-optimized tables, if you think in such direction then please start using computed columns in memory-optimized tables

6 comments:

Merlin Maarit said...



It is very helpful for me. Keep blogging like this.


Healthcare Analytics Company

Finance Analytics Company

Telecom Analytics Company

Retail Analytics Company

Analytics Company

US IT Staffing Agency

Sujitkumar said...

Very Nice tutorial. Really helpful for a lot of information about ASP …. Please keep update some more…………

viji said...

you are posting a good information for people and keep maintain and give more update too.
seo company in india

Philips Huges said...



Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

Personal Installment Loans
Title Car loan
Cash Advance Loan

Inwizards Incorporation said...

Nice post . Thanks for the shearing valuable information. I really fiend this type blog. Special thanks to writer.
Asp.net developers

Isabella Olivia said...


This information is impressive; I am inspired with your post writing style & how continuously you describe this topic.


Pawn Shop

Pawn Loans

Pawn Shops

Pawn Loan

Pawn Shop near me