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


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. 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

Inwizards Incorporation said...

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

Inwizards Incorporation said...

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

Article is very different in the topic points and the way of writing.Keep updating more articles.

Python Training in Chennai

Coepd said...

At Coepd (Center of Excellence for Professional Development) we practice Object-Oriented Programming concepts and mentor .Net Platform, C#.NET, ADO.NET which helps the attendees to build database-driven Web applications and Web Sites successfully. We also guide the attendees to develop web-based enterprise applications using ASP.NET and Visual Studio which comforts in developing the Web Services using .Net framework in Service-oriented Architecture. The Internship Program Also covers Frontend design technologies HTML, HTML5, CSS, CSS3, XML, Bootstrap, JQuery, Angular JS, and AJAX. Our collaborative ecosystem comprising of Partnerships with Software Companies enables real time software development life cycle experience.

Atom Steels said...

The Car featured content undergoes a thorough review process to ensure that it meets the highest standards in order to serve as the best car spare parts and fit the goals.

Car Accessories in OMR

Kalai chellam said...

Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.

Restaurant in OMR
Apartments in OMR
Villas in OMR
Resorts in OMR

kabeesha said...

Thanks for the informative article. This is one of the best resources I have found in quite some time.Nicely written and great info. I really cannot thank you enough for sharing.

Herbalife in chennai
wellnesscoaches in chennai
Weightloss in chennai
Weightgain in chennai

Susmitha Bommepalli said...

Excellent blog. I loved it very much. Really it was very impressive. Keep giving like this.
Best Data Science Online Training Institute In Hyderabad | Online Data Science Training
Data Science Online Training Institute In Hyderabad
Data science online training in hyderabad
Best data science training in hyderabad

Unknown said...

Best selenium online training institute `

supreet said...

Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this. best sap simple finance online training institute in hyderabad

sivasurya rg said...

BIG DATA Technologies provides you with a state of the art software which combines modern GPU technology (Graphic Processing Units) with the best practices in today’s Big Data platforms, providing up to 100x faster insights from data.
Bigdata Training in Chennai OMR

suganya d.suganya said...

Robotic Process Automation (RPA) is one of the most exciting developments in Business Process Management (BPM) in recent history. Some industry experts believe it may be even more transformational than cloud computing transformational than cloud Automationminds team. (RPA)Automationminds lets you program in (RPA),
Robotic Process Automation Anywhere and course bluePrism

getha said...

We can learn a lot about Why Deep Learning Works by studying the properties of the layer weight matrices of pre-trained neural networks. And, hopefully, by doing this, we can get some insight into what a well trained DNN looks like–even without peaking at the training data.
MACHINE LEARNING training in chennai

muthu said...

Robotic Process Automation course

Priyadarshini Yadav said...

Thank you for sharing wonderful information with us to get some idea about that content. check it once through
Machine Learning With TensorFlow Training and Course in Tel Aviv
| CPHQ Online Training in Beirut. Get Certified Online

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.