Brian,

I will perform manual failover later today and test out if SNMP trap was generated.

Thanks a lot!

Theoretically, under the assumption that the statistics are recently updated (and indexes are not fragmented), SQL server chooses one index over another because choosing that one would result in a better...

Guys,

Does anyone also know whether or not SNMP trap is generated when failover occurs?  I ask because we have a monitoring system set up which can...

Noel,

I found something similar to what you have suggested here: http://www.databasejournal.com/features/mssql/article.php/3426431

although, the solution appears a bit more complicated than I need it to be ...

Thank you

Thanks Noel.  I usually do that as well!

I don't think we have any off peak hours.  We have some low usage hours, and this is when I scheduled to run INDEXDEFRAG.

I have noted all the suggestions above. ...

I'll try that.

Thanks a lot!

Thanks for the info everyone !!!

John,

Thanks for the info ... it is helpful!

uofmoo,

Did you set the limit for the transaction log  growth during the execution of the query which you wanted to cancel or during the rollback operation of the query you...

Thanks for the info uofmoo.

I forgot to mention that this database is not currently being used by anyone (for next 24 hours or so).  Does anyone know if I detach...

Rudy,

I actually just tried it [i.e. table drop].  You are correct.  This operation was just hanging as well.  After a minute's wait I stopped this query and it seems the...

Guys,

I have a similar situation.  The query ran for 11 hours, inserting into table A using a DTS package.  I killed the query ... its been rolling back 5 hours already...

I don't think it is a good idea to shrink the TRANSACTION LOG file.  If you do do it, you have to have a reason, such as:

"It grew due to...

Guys,

I rebooted the machine ... and the problem seems to have vanished. Now my transaction log for the TEMPDB database is at 2GB, but it is using...