Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance.

NEW! Take the stress out of .NET deployment Eliminate the risk in deploying manually to live systems using Deployment Manager, the new tool from Red Gate. Try it now.