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 – 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 […]
SQL 2019 – Custom Capture of Query Store stats
Query store is a feature of SQL server that tracks and captures information about queries. Database administrators will find query store useful in trouble shooting performance issues. Most […]
SQL 2019- Scalar UDF inlining
Scalar UDF are notorious for their performance issues. The most common reason they cause issues is due the fact that the logic is applied on each row. So […]
SQL 2019 – Worker Migration
Worker migration in SQL 2019 is the process by which workers that are bound to a scheduler can be unbound and run on another scheduler in order to […]
SQL 2019 – Indirect Checkpoint
Checkpoint in SQL server is the process by which dirt pages are written to disk. However it had a flaw that cause issues and the solution of which […]