What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered.

Even simple, this query was causing troubles on our production systems. The query is generated from .NET Entity Framework. A simple Continue reading What does an Index mean to a Query

ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017

You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with the MEMORY_OPTIMIZED option set to ON. Like in the example below

try to create the next constraint Continue reading ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017

Why you should not update Primary Key values

Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following:

The query was throwing the following error: The query processor ran out of Continue reading Why you should not update Primary Key values