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 […]
SQL 2019 – Security Best Practices
Early November I had posted I would be conducting a series of sessions on MS SQL server. The response was really great and while I intended to do […]
SQL 2019 – Database Snapshot for In-Memory OLTP table
Traditionally Database snapshots have been used mainly to get Database mirroring secondary’s to act like Readable secondary. As you might be aware in mirroring etc. the databases are […]
SQL 2019- Max DOP and Memory Configuration
Probably the most useless recommendation and as far as I am concerned not a feature. Why? If you are a DBA you know that DOP and Memory limits […]
SQL 2019- Optimize for sequential key
Last page contention is one of the textbook examples for latch contention. This frequently occurs on tables that are narrow and have high inserts happening against a sequential […]