Recently one of the clients sent me images from the execution plan and his question was about the Number of Rows Read in the SQL Server Execution plan.
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.