It turns out it was a job after all. I was able to run sp_who2 at the right time and that's how I saw a job was running.
We are running SS2005 behind our website. We are still using classic ASP. We are experiencing timeouts when trying to open a connection. This started...
Hello, We have two 2000 Sql Servers, one running on MS server 2000 and the other on MS Server 2003. They are also separate virtual machines via...
Same performance issues. It looks like my problems are related to changing a decimal(9,2) to decimal(14,2). I changed them back to (9,2) and I'm...
No, but I did run DBREINDEX to improve the scan density, which was pretty bad. Probably less than 40% on all five indexes.
Hello, We have two updates running concurrently one of which is running an update of a couple million rows. It usually takes a few minutes, but...
Satya, Thanks for the response. I have some more information. The execution is done in serial. The DTS uses a data transform task with a query...
Hello, We are using sql server 2000 standard edition on windows server 2000. We have several DTSs that move millions of rows of data. In the past...
Separate names with a comma.
