INPUT and OUTPUT type parameters in stored procedures

Output-only parameters do not exist in the T-SQL procedures. They are all either input-only or input/output. The OUTPUT keyword in the procedure’s definition or its invocation, designates the input/output type of a parameter. The shorten CREATE syntax for stored procedure Continue reading INPUT and OUTPUT type parameters in stored procedures

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