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

25 comments:

Inwizards said...

Nice blog. Thanks for sharing such great information.
.Net Development Company India
Hire .Net Developers India

Inwizards said...

very nice,but if any one gives some more explaination it will some more better to under stand.thanks... Hire .Net Developers India

Unknown said...

Best selenium online training institute `

Anonymous said...

Very good information. Its very useful for me. We need learn from real time examples and for this we choose good training institute, we need to learn from experts . So we make use of demo classes . Recently we tried azure demo class of Apponix Technologies.
https://www.apponix.com/Microsoft-Azure/Microsoft-Azure-Training-in-Bangalore.html

ramya said...

And indeed, Iam just always astounded concerning the remarkable things served by you. Some of the facts on this page are undeniably the most effective I have had.
Big Data Hadoop Training in Chennai
Advanced Linux Training in Chennai
Cloud Computing Training in Chennai
Top Software Testing Training in Chennai
Blue Prism Training in Chennai
Angularjs Training in Chennai
MCSE Training in Chennai
AI Training in Chennai
SEO Training in Chennai

TNK Design Desk said...

best web design company in gurgaon
best website design in gurgaon
website design services in gurgaon
website design service in gurgaon
best website designing company in gurgaon
website designing services in gurgaon
web design company in gurgaon
best website designing company in india
top website designing company in india
best web design company in gurgaon
best web designing services in gurgaon
best web design services in gurgaon
website designing in gurgaon
website designing company in gurgaon
website design in gurgaon
graphic designing company in gurgaon
website company in gurgaon
website design company in gurgaon
web design services in gurgaon
best website design company in gurgaon
website company in gurgaon
Website design Company in gurgaon
best website designing services in gurgaon
best web design in gurgaon
website designing company in gurgaon
website development company in gurgaon
web development company in gurgaon
website design company
website designing services

shri said...

very nice post...
internship report on python
free internship in chennai for ece students
free internship for bca
internship for computer science engineering students in india
internships in hyderabad for cse students 2018
electrical companies in hyderabad for internship
internships in chennai for cse students 2019
internships for ece students
inplant training in tcs chennai
internship at chennai

Praisy Margret said...

useful information..nice..
devops-engineer-resume-samples
digital-marketing-resume-samples
digital-marketing-resume-samples
electronics-engineer-resume-sample
engineering-lab-technician-resume-samples
english-teacher-cv-sample
english-teacher-resume-example
english-teacher-resume-sample
excel-expert-resume-sample
executive-secretary-resume-samples

sara jenifer said...

I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here
BCOM 1st Year Exam TimeTable 2020
Maharaja Surajmal Brij BCOM 1st Year Exam TimeTable 2020

Janu said...

Nice Article! I learn more important information from your post. It was really interesting and useful post. I like more updates to your blog....



Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery


vijay said...

Really it was an awesome blog...very interesting to read..You have provided an nice information..I am really happy with your blog because your article is very unique and powerful information.....
Salesforce Training in Chennai

Salesforce Online Training in Chennai

Salesforce Training in Bangalore

Salesforce Training in Hyderabad

Salesforce training in ameerpet

Salesforce Training in Pune

Salesforce Online Training

Salesforce Training

dataanalyticscourse said...

Happy to visit your blog, I am by all accounts forward to more solid articles and I figure we as a whole wish to thank such huge numbers of good articles, blog to impart to us.
360DigiTMG Data Analytics Course

tejaswini said...

I need to communicate my deference of your composing aptitude and capacity to make perusers read from the earliest starting point as far as possible. I might want to peruse more up to date presents and on share my musings with you.
pmp certification in malaysia

devika iangar said...

I see the best substance on your blog and I unbelievably love getting them.
difference between analysis and analytics

Bhrugen Patel said...

If you are looking for the ultimate learning recourse for .NET developers then Dotnetmastery.com is here to provide you best online E-courses to learn the .Net and more courses online at best prices.

asp.net core bootcamp

360digitmgdelhi said...

This was not only extraordinary in truth this was truly ideal your ability recorded as a hard copy was incredible.
iot training in delhi

prathyusha said...

Truly overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. Much obliged for sharing.Best data analytics course in Hyderabad

tejaswini said...


I have bookmarked your site since this site contains significant data in it. You rock for keeping incredible stuff. I am a lot of appreciative of this site.
HRDF training

tejaswini said...

I have bookmarked your site since this site contains significant data in it. You rock for keeping incredible stuff. I am a lot of appreciative of this site.
what is hrdf

Unknown said...

Thanks for updating Tableau Online Training
AWS Online training
Dot Net OnlineTraining
DevOps Online Training
Selenium Online Training

360digitmg said...

Just pure brilliance from you here. I have never expected something less than this from you and you have not disappointed me at all. I suppose you will keep the quality work going on.
Digital Marketing Training Institutes in Hyderabad

Anonymous said...


Thanks, this is generally helpful.
Still, I followed step-by-step your method in this
dot net course
.net online training

Anonymous said...

Python training in bangalore
Machine learning course in bangalore
Data Science Online Course in Bangalore
Learn Storage Automation (Using Python) in Bangalore BTM
Cloud Computing Training in Bangalore BTM

Indian Keto Diet said...

Thanks admin for the post, Its really a nice post and Looking for more blogs like this. Please stay updated..!

food darzee reviews

360DigiTMGAurangabad said...

Nice blog. Found this while searching through
data analytics course in aurangabad