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?
SQL SERVER – Having Two Identity Columns for A Single Table
In yesterday’s session, a DBA asked an interesting question that if it is possible to have two identity columns for a single table. Yes and No.
SQL SERVER – Killing DBCC SHRINKFILE Process – Is it Safe?
Shrinking the data file is a very bad thing and you can read it. Now let us learn about if Killing DBCC SHRINKFILE Process is safe or not?
SQL SERVER – Rows Sampled – sys.dm_db_stats_properties
Here is the question asked in my yesterday’s Comprehensive Database Performance Health Check about rows sampled from sys.dm_db_stats_properties.