I run a monthly DTS job that loads the contents of a text file into a temp table, then an insert query does some simple manipulation of the data and passes it to a cumulative table. Each of the tables resides in a different filegroup on a different drive share.
During my last update, the insert never finished. The query ran for over 20 hours before we killed it(usually takes less than 1) and the transaction log never grew. It appears that although the cumulative file is set for unristricted growth and there is plenty of drive space, the table will not accept data. Any ideas on what might be the cause?
During my last update, the insert never finished. The query ran for over 20 hours before we killed it(usually takes less than 1) and the transaction log never grew. It appears that although the cumulative file is set for unristricted growth and there is plenty of drive space, the table will not accept data. Any ideas on what might be the cause?