Simple Recovery changes recovery options before it changes a performance diagnosis. I choose it from the agreed recovery requirements.
SQL SERVER – Running Log Backup While Taking Full Backup
A full backup and log backup can overlap on one SQL Server database. A customer noticed both during a slowdown.
Spinlock in SQL Server: What It Is and How to Read One
A spinlock in SQL Server is a very short lock on an internal structure, and a thread that waits for it keeps spinning on the CPU instead of sleeping. This post explains how a spinlock differs from a latch and a lock. It reads sys.dm_os_spinlock_stats, measures a ten second window and lists the Extended Events that report backoffs.
SQL SERVER – What is Latch?
What is Latch protection in SQL Server was a reader question after my scheduler video. A latch provides short-lived internal synchronization.
SQL SERVER – SQLOS Scheduler and the Process States
I strongly suggest that you first watch it before we continue on today’s topic of SQLOS Scheduler and the Process States.
SQL SERVER – NULL Values and CONCAT Function
A lot of SQL in the Sixty Seconds video recently, we will be looking at a very interesting T-SQL CONCAT function and how it works with the NULL Values.
Pinned Tab – SSMS Efficiency Tip – SQL in Sixty Seconds #121
Lots of people asked me to share the SSMS efficiency tip so I have shared the same in this blog post. Today’s topic is the pinned tab in SSMS for efficiency.