Thing is, we're accessing this puppy through SAS, the database\r\nappears as a (fairly) standard SAS library, access is through ODBC. So\r\nmy own control through code to what's going on with the table itself is\r\nrelatively limited. I'm also not able to add/drop indices on the SQL\r\nServer tables from within SAS, so a number of options of r easing the\r\nupdate process are somewhat foregone.
\r\n\r\nOne option, of course, is that there isn't a good solution to this\r\nand we'll either have to suffer or look for an alternate solution.
\r\n\r\nI'll also see what I can find out about the SAS side of affairs and\r\nwhat sort of requests it's generating for the DB.
\r\n