The client wanted to know if the index help with the DELETE command as well. The answer is yes, Indexes do help with the DELETE statement.
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 – What is Latch?
Earlier I wrote about SQL SERVER – SQLOS Scheduler and the Process States, lots of people liked the blog post and asked me another question – What is Latch?
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.
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.