Last week in of the SQL Community Forum, one of my friend asked the following question If I have 2 Tlog files for one database, how will these files fillup? A) File 1 will be filled first and then File 2 B) Both the files will be filled together. If B is true then how…
Following are links to my blog post on SQLServerGeeks.com. Hope you find them useful Does Parallel Plan for rebuild index impact the fragmentation of index? http://sqlservergeeks.com/blogs/Parikshit/personal/427/does-parallel-plan-for-rebuild-index-impact-the-fragmentation-of-index Parikshit Savjani Premier Field Engineer
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…