One of the questions I had received from a client was about how to find out fragmentation in columnstore index. Let us discuss it today.
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.