Blogs on SQLServerGeeks

Following are links to my blog post on Hope you find them useful Does Parallel Plan for rebuild index impact the fragmentation of index? Parikshit Savjani Premier Field Engineer


I killed Reindexing Job and now it is in KILLED/ROLLBACK State for more than 9 hours

  One of our Customers ran into this issue where in he killed a Reindexing Job and following that it went into KILLED/ROLLBACK State and was in that State for more than 9 hours. First of all we would not recommend you to kill Job like Reindexing or DBCC CHECKDB which performs internal operations. However…