DB Options – ANSI WARNINGS | ANSI PADDING and more

By | 2020-03-19

https://youtu.be/aoAijAWpEAk

In this video we cover multiple database options most of which are fairly easy to understand and don’t really require significant research before being set. Often these settings are enabled by default and Microsoft recommends they remain that way. Some of the options we cover are listed below

ANSI WARNINGS – Must be set to ON

ANSI PADDING – Must be set to ON

CONCAT_NULLS_YEILDS_NULL – Set as per need

NUMERIC_ROUNDABOURT – Set as per need

Two Digit date Cutoff – Not change required

We cover how these options behave using T SQL scripts and things to watch out for such as unexpected behavior or deviation from what is mentioned in BOL.

Category: Uncategorized

About admin

This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.