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

Find Char nullables to possibly go for not nullables

I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to understand what does it mean to have not nullable columns against nullable. Continue reading Find Char nullables to possibly go for not nullables