SQL 2012: Indirect Checkpoint Explained !!!

Recently I got an opportunity to present at the SQL Server day organized by www.SQLServerGeeks.com on SQL 2012 Indirect Checkpoints.In this post I would like to explain the same for the benefit of wider audience. The focus of SQL 2012 has always been to provide a reliable,robust and Highly Available Database Solution to give the… Continue reading SQL 2012: Indirect Checkpoint Explained !!!

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… Continue reading I killed Reindexing Job and now it is in KILLED/ROLLBACK State for more than 9 hours