One of my client of Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works
What is Temp Stored Procedures? – Interview Question of the Week #294
Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.
SQL SERVER – Running Log Backup While Taking Full Backup
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.
25 Recent SQL in Sixty Seconds Video
I have been recording SQL in the Sixty Seconds videos for many years. I would like to share my recent 25 SQL in the Sixty Seconds video.
SQL SERVER – Delete Statement and Index Usage
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.