In my career, this is I think 2 or 3 rd time I have seen this one, so do not consider this as a generic solution. How to Disable Rowgoal Optimizer works?
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.
My client of Health Check sent me an email asking if there is any other method when we have to attach an In-Memory Database with T-SQL.