Recently a client of mine asked me – When to Use DBCC CLEANTABLE? A question to be discussed in Comprehensive Database Performance Health Check.
SQL SERVER – Correcting Space Allocation with DBCC UPDATEUSAGE
I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE.
SQL SERVER – Quick Look at Suspected Pages
Well, let us take a Quick Look at Suspected Pages which contains details about corrupted pages. They have been running DBCC commands regularly.
SQL SERVER – DBCC DBREINDEX and MAXDOP Not Possible
Yes, you read it right it is not possible to use DBCC DBREINDEX with MAXDOP hint as far as I know. If there is any method to use it.
How to Change Database File Size? – Interview Question of the Week #296
Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
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?