constraints – Igor Micev

The CHECK constraints unlike behaviours

Posted on June 13, 2016 by Igor Micev — No Comments ↓

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns TRUE or FALSE based on the logical operators. CHECK constraints are Continue reading The CHECK constraints unlike behaviours→

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

Posted on June 6, 2016 by Igor Micev — No Comments ↓

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


--table
CREATE TABLE dbo.People (
 Id int primary key nonclustered,
 InfoJson nvarchar(max) -- nvarchar(100), nvarchar(1000)
) WITH (MEMORY_OPTIMIZED=ON)

--table

CREATE TABLE dbo.People (

Id int primary key nonclustered,

InfoJson nvarchar(max) -- nvarchar(100), nvarchar(1000)

) WITH (MEMORY_OPTIMIZED=ON)

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

Posted on March 1, 2016 by Igor Micev — No Comments ↓

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→