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.
One of the conversations that keep on coming up at what level one should set the fill factor – Instance Level or Index Level.
I will describe in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a nonclustered primary key.
However, while modifying it we faced a unique challenge that we can’t actually alter index to add columns. Let us discuss that today.
After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.