They found out that they have a full backup running for one of the largest servers and at the same time they are running a log backup on the same server.
SQL SERVER – What is Spinlock?
After reading both the blog post, I got another question from my client on What is Spinlock? Let us discuss today What is Spinlock.Â
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.
Activity Monitor and Running Query – SQL in Sixty Seconds #115
Activity Monitor can come handy when you are in trouble as well. We will see how we can take the help of Activity Monitor to track Actively Running Query.
Patch Your SQL Server – SQL in Sixty Seconds #100
When did you last time patch your SQL Server? I often discuss this question with my clients, I get many different kinds of answers.
SQL SERVER 2019 – Disabling Scalar UDF Inlining
Working on the Comprehensive Database Performance Health Check, we will learn how I helped a client by Disabling Scalar UDF Inlining in SQL Server 2019.Â