...
- 06:58 (Patrick) I switched to the recreated TB tables. The job started at 6:58am and completed at 7:06.
- I checked the problem query on both the TA and TB tables and it looks like the indexes are still being used.
- I noticed that there are 151 pairs of duplicate EID's in the SECTION table. Have we considered changing the view to weed those out?
Friday 10-05-2007
Thursday 10-04-2007
- 16:00 (Patrick) Tried to run update scripts on all 5 tables. The updates delete didn't succeed on the cm_enrollment and cm_membership tables