BE SHARING

In-Memory OLTP

SQL Server 2016 : availability groups and performance improvements

27.10.2015 by Microsoft Team

During the last SQL Saturday in Paris, I had the opportunity to co-present the new SQL Server 2016 features and one of my topic concerned the availability group’s enhancements. I mentioned the(…)

Development & Performance

Variations on 1M rows insert (3): using SQL Server In-Memory features

19.05.2015 by Microsoft Team

Let’s continue with this series about inserting 1M rows and let’s perform the same test with a new variation by using SQL Server In-Memory features. For this blog post, I will still use a minimal configuration that consists of only(…)

Hardware & Storage

In-Memory OLTP: Hash and Range indexes

18.05.2015 by Stéphane Savorgnano

Since SQL Server 2014 CTP2, Microsoft has introduced a new kind of index which is the Range index. We have now two ways for indexing an In-Memory table: using either an Hash index or a Range index. These two indexes(…)

Database management

SQL Server Tips: How to know if In-Memory Feature is supported by your server?

18.05.2015 by Stéphane Haby

A customer asks me, how to know if In-Memory Feature is supported by my SQL Server server? An easy way is to check the edition, version etc. but now, you have directly a property for that. On msdn(…)

Application integration & Middleware

Memory management, OOM issues with SQL Server 2014 In-memory OLTP

22.01.2015 by Microsoft Team

Last week I gave a workshop about SQL Server 2014 and the new features. The first day we worked on new In-memory OLTP and different topics such as the new internal storage, the new transaction processing behavior or the(…)

Database management

SQL Server 2014: Readable Secondary with In-Memory objects

06.02.2014 by Stéphane Savorgnano

In-Memory OLTP is one of the best new functionalities of SQL Server 2014 as it was the case with AlwaysOn and SQL Server 2012. In-Memory OLTP is fully integrated with AlwaysOn and also with AlwaysOn Availability Group. During my(…)