SQL Server Performance

Things to consider before running Update Statement

Discussion in 'SQL Server 2005 General DBA Questions' started by jstevenson, Mar 6, 2010.

  1. jstevenson New Member

    I will be updating a table in a single column. The update statement joins several table. Besides disabling the trigger before I execute this process, what else do I need to consider (Critical/Non-Critical?). Any suggestions?
  2. Adriaan New Member

    What does that trigger normally do, and what is the reason for disabling it?
    Can you take the database off-line, or can you schedule the update in down-time?
    If it's critical data, you might consider copying all rows that you will update into an archive table, before running the update.

Share This Page