January 04, 2013
Subscribe to:
Posts (Atom)
SQL Server Online Rebuild Index Bug
What do you do if you have a very large table and you can’t take an outage window to rebuild the clustered index offline? · E...
-
Database Mirroring and index maintenance in AWS Database Mirroring, the database has to be in the full recovery mode, so all index rebuilds... -
Move distribution database to another drive: There are scenarios in SQL server Replication that we need to move datafiles and logfiles of di...
-
1. To change the scheduled time of oracle job and force it to run at certain time, use the set_scheduler_attribute procedure.e.g. To start j...