I've used this query in a daily job to populate a database size history table that keeps 30 days of size data so I can get an idea of growth...

Ok I found it. We added a few columns to the results and did a self join on a view 3 times to get the data. But that's...

It's likely that we'd stay under a 100 rows 95% of the time. I've just been doing some side by side tests of a previous revision of the procedure...

Dean Cochrane (3/9/2009)

It's recompiling because the schema has changed. This may be due to declaring temp tables partway through the procedure. At least, that's where I've run into this issue....

Well I don't get to pick how this product is deployed, I've got 3000 installations of it worldwide. IBM is still selling smaller servers with these processors. I've...

80 tables! Wow. I've known about the hyper-threading issues for a while, but never had an installation of this product really suffer from it. I think that's...

Nevermind, I did find one using the objectproperty function.

http://www.sqlmag.com/Article/ArticleID/95960/Optimizing_Queries_for_Fact_Tables.html

Duration was the only filter. I wish I knew a little more about the web service making the call, but as soon as I asked a developer a question...

I found the cause of the problem, an incorrect web service was installed on a server that was making the calls. Still weird that I never saw a block...

SQL2000 on Sp3

I was afraid of that. 

Its got to be something funky with our server build, I just hate to open a PSS call on something like this.  I'm...

It doesn't matter where I manually start it from, Services applet or EM, it starts up just fine.

The first bit from the begining of the post is the total contents...

They both use the the same domain\account to authenticate.  It is an account created specifically for these 2 services.

It is the default instance of SQL Server. 

We use Windows Authentication...

They both use the same account, not localsystem, to start. 

YEs, by "Start Manually" I mean that I started it from the Services applet.

There have not been any changes to the 'sa' password or the service account logins that SQLServerAgent...

VG, thanks for the reply.  Yes after some further research I discovered that we have dropped and receated a column on that table repeatedly through a series of code updates. ...