An index can help a DELETE statement locate rows to remove. A customer asked whether indexes benefit modifications alongside SELECT queries.
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.
SQLOS Scheduler and Process States: Running, Runnable and Suspended
SQLOS scheduler and process states, in simple words: the processor, the ready queue and the waiting queue. After my SQL in Sixty Seconds video, people asked how to map them, so here is the answer.
Where are SQL Jobs Stored? – Interview Question of the Week #293
Question: Where is SQL Jobs Stored?
Answer: In MSDB Database in dbo.sysjobs table. Let us learn about it in today’s blog post.
CONCAT and NULL – SQL in Sixty Seconds #123
I have decided to convert the blog into the video of SQL in the Sixty Seconds. Let us learn about CONCAT and NULL – SQL in Sixty Seconds #123.
Sleeping vs Suspended Process – SQL in Sixty Seconds #122
There are so many different statuses of the processes in SQL Server. Let us learn today the difference between Sleeping vs Suspended Process.