60b460a5   
   From: esquel@sommarskog.se   
      
   Dave (djohannsen2@gmail.com) writes:   
   > i think i have one last question then i'm all done.  do you still   
   > recommend not going forward with schema changes such as adding NSO_ID   
   > on the ABC_Person table, or adding a join table to help out as i   
   > mentioned earlier?   
      
   That's very difficult for me to answer, because I don't know that   
   this NSO_ID etc are in real life. If you add the column, you must also   
   get the values for it from somewhere. Maybe that is a trivial, I don't know.   
   But as with all denormalisations, you will have to pay the price in more   
   complex updates. If ABC_Person is updated in a single place, it's a not   
   a big deal, but if it's updated in many places or manually, there is a   
   risk that the new column is not maintained correctly.   
      
   On the other hand, from my uninitiated position, it could just as well be   
   the case that it is an oversight that this column and the join table is   
   missing.   
      
   But under the assumption that the query you have is correct, I don't believe   
   there is any performance to gain by adding these columns.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)