sorry for the misleading info about tempdb. If you remove autogrow on tempdb it will be created according to the model db as Brian says. I increased the model db...

As Brian says; predicates in the join rather than the where clause, additional indexes (particularly a clustered index on the column being sorted) will help. the other 2 points i...

I have had this a few times. I tried restarting MSDTC and that didnt work. It seems to happen for me with external procedure calls  (xp_cmdShell, dtsrun etc). I think sql might...

cheers that worked perfectly

how did you reinstall mdac? i had a problem with vs.net and reporting services where it needed an older verison of mdac but i couldnt revert to an older version.

we had a similar problem when extracting data through an asp application. We thought it was something to do with the money data type and a problem with the code...

I have tried DBCC SHRINKFILE ('filename', EMPTYFILE) whish reduced one off the files to 1MB and left the other at 42GB. I coudlnt drop the smaller file as it wasnt...

Reply thx for the help.

I am going to try your suggestions out throughout this month, with a background trace on some key sp.

Transaction log is set to 1gb and regularly truncated, then reset to 1GB. The database is set to simple logging due to the large number of records updated/inserted. I am...