learned tricks: Following SQL clause impact query performance: 1. Parses JSON textby OPENJSON() syntax 2. Timestamp format Observed query speed [test3] >>[test1] 3. Update in SQL process speed is lower than insert with specified column new constant value 4. Prefer to use NOT NULL in create schema. NULL cost extra space or other unexpected outcome… Continue reading SQL tricks