title: Updating SQL Server table columns based on a where clause multiple column null checks
body: <p>I'm just curious if there is a more optimized way of performing the following script? There are several columns we are updating and setting to NULL if they are Not already null. I am worried on a 1000+ record table this could take a while to compile all these OR checks.</p>
  <pre><code>UPDATE center 
  SET Email = 'test@test.com', 
      Phone = NULL, 
      FWD = NULL, 
      Default = NULL, 
      Serv = NULL 
  WHERE 
      Email IS NOT NULL OR 
      Phone IS NOT NULL OR 
      FWD IS NOT NULL OR 
      Default IS NOT NULL OR
      Mkt IS NOT NULL OR
      Serv IS NOT NULL
  </code></pre>