https://youtu.be/eXLELsEVAP0 It’s become significantly rarer for database corruption to occur nowadays because of hardware and software improvements. In older version of SQL Server it was fairly common for […]
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 […]
DB Options: – ANSI NULL DEFAULT ON
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 […]
DB Options: – ANSI NULL DEFAULT ON
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 […]
DB options: – Auto Shrink = OFF
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 […]
DB Options: – AUTO UPDATE STATS / ASYNC
https://youtu.be/8ugpVfPzvz4 In this video we are going to talk about auto update statistics. This is a feature in the database engine that automatically triggers a stat update when […]
DB Options: Auto Create Incremental Statistics ON
In this video we cover the next database option which is AUTO CREATE INCREMENTAL STATISTICS. This option is useful when the database has partitioned tables. It allows the […]
DB Options: Auto Create Stats and why it should be ON
Auto create stats is one of those database options that every DBA knows they should set to ON. In this video we explore what happens when you set […]
Database Options – Auto Close and why should set it to OFF
Auto close is one of those features that should have been removed long back. The setting needs to stay at default of OFF for reasons that will be […]
Temp table Owner
Recently I came across a post on LinkedIn which required identifying the user who created a temp table. This is an interesting use case and thought I’d write […]