DB Options – ANSI WARNINGS | ANSI PADDING and more
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.
Need more information? Visit https://www.enabledbusinesssolutions.com
To know more about Jayanth Kurup visit http://www.jayanthkurup.com
Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years’ experience. He has worked with companies like Microsoft, IBM, HCL, Wipro, Well Fargo, Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.
In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc
You can also reach Jayanth via his LinkedIn profile below / jayanth-k. .
music from HAAWK