From: markp28665@gmail.com   
      
   A recent Database Engine Tuning Advisor run on a SQL Server 2008 R2 RTM system   
   has several recommendations that puzzle me because the recommendation is for a   
   two column non-clustered index on the same two columns that are the clustered   
   PK.  In one case    
   there are only two other columns consuming a total of 5 bytes on the row so I   
   just cannot see any valid reason for this recommendation.   
   - -   
   There is a index reorganization job I added to the system that runs every   
   Sunday but statistics update is left to SQL Server.     
   - -   
   Does anyone have a good idea of what would cause these recommendations?   
   - -   
   -- Mark D Powell --   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)