Viewing 9 posts - 16 through 24 (of 24 total)
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...
November 29, 2005 at 11:11 am
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...
November 29, 2005 at 10:26 am
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...
June 9, 2005 at 5:27 am
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.
May 23, 2005 at 8:59 am
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...
November 9, 2004 at 2:53 am
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...
August 9, 2004 at 9:29 am
Reply thx for the help.
I am going to try your suggestions out throughout this month, with a background trace on some key sp.
January 13, 2004 at 11:00 am
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...
January 13, 2004 at 10:45 am
Viewing 9 posts - 16 through 24 (of 24 total)