Monthly Archives: March 2020

Tackling Corona Virus Long Term

By | March 21, 2020

At this point it seems Corona and its impact is here for the long term. As the days go by I see even more people taking extreme measures often out of fear or a lack of understanding the problem. Social media and Whatsapp has played its share too. The spread of Corona can happen through… Read More »

DB Options – ANSI WARNINGS | ANSI PADDING and more

By | March 19, 2020

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… Read More »

DB Options: SET ANSI Nulls

By | March 18, 2020

https://youtu.be/QfB2v6QQej8 ANSI NULLS dictate how SQL Server responds when the equal to (=) operator is used to check for NULLs. Keep in mind that the IS NULL condition works regardless of what ANSI NULL setting is used. When ANSI NULLS are ON using a query like ColA =NULL will not return any results. Setting ANSI… Read More »

DB Options: – ANSI NULL DEFAULT ON

By | March 4, 2020

https://youtu.be/SAzmOEqVoIQ Another one of the database options which doesn’t serve any real purpose. As shown in this video the setting is overridden by session level settings so it doesn’t make sense to set it at Database level. This option default the NULLAbility of columns when creating the table or altering it. When set to off… Read More »

DB Options: – ANSI NULL DEFAULT ON

By | March 4, 2020

https://youtu.be/SAzmOEqVoIQ Another one of the database options which doesn’t serve any real purpose. As shown in this video the setting is overridden by session level settings so it doesn’t make sense to set it at Database level. This option default the NULLAbility of columns when creating the table or altering it. When set to off… Read More »

DB options: – Auto Shrink = OFF Why you shouldn’t shrink if possible.

By | March 2, 2020

https://youtu.be/ph070n6lLU4 The use of AUTO SHRINK I think needs no explanation. Almost anybody who has worked on SQL Server understands the way databases can quickly grow. In these cases we can see growth happens in two places, the database file and the log file. The database file gets highly fragmented when it is shrunk. The… Read More »

DB options: – Auto Shrink = OFF

By | March 1, 2020

The use of AUTO SHRINK I think needs no explanation. Almost anybody who has worked on SQL Server understands the way databases can quickly grow. In these cases we can see growth happens in two places, the database file and the log file. The database file gets highly fragmented when it is shrunk. The log… Read More »