In-Memory OLTP Archives - Chantified Lens

T-SQL Tuesday #117 – Memory Optimized Tables

February 11, 2026August 13, 2019 by Chantified Lens

Welcome to this month’s T-SQL Tuesday post ,which is about when I have used Memory Optimized Tables (MOTs). Now, this month’s T-SQL Tuesday is hosted by the organizer Steve Jones, and I suspect he stepped in at the last minute. Steve invites us all to write about when we have decided whether to use MOTs. … Read more

A unique review of SQL Server index types

February 11, 2026October 18, 2018 by Chantified Lens

Introduction I want to do a unique review of SQL Server index types in this post. In order to help raise awareness about some of them. Because one thing I have noticed in various places is that people still tend to use the traditional clustered and non clustered indexes. However, I rarely see the filtered … Read more