I wish I could have made 120K after less than 5 years in the field ...

Even after 25+years I am not there yet ...

Does anyone see anything wrong with this...

Yelana, I may be mistaken ... blame it on the 'ravages' of middle age ...

... so the 4th qualifier is missing in one place ... bfd ... that's what QA and etsting are for ...

... besides that ... it is a really cool query...

None.

How else could I be the 'unknown DBA' ...

Yes. Sometimes just hitting certain size/rowcount threshhold can case this. Another potential reason is a large volume of insert/update/delete activity on tables as well. When running UPDATE STATISTICS on your...

I have 25+ years experience and cannot meet all of those requirements !

If they hire one person I'll bet the top end is 60-65K to boot.

Now if they were really...

it seems that noone mentioned this solution for SQL 2000 - go to integrted security, mind you it might be a grain of salt as well but possibly less than...

You might want to try executing:

• DBCC UPDATEUSAGE
• UPDATE STATISTICS
• sp_recompile for all tables
• sp_refreshview for all views

just prior to your production run.

Google is your closest friend, Yahoo is a close friend ...

I agree with Steve that it sounds like it may be related to the AS400 side of things. It could either be something running (or not) on the AS400 or...

Since they are not really production they could have used the Developer Edition instead of the Enterprise Edition of SQL 2005 with a cost saving of $374,912 ...

It may be of some help if you could provide a little more information about what the job does. Are there any other job(s) executing at that time ? Were...

... there is never time to do it right ...

... but ...

... there is always time to do it again !!!

That 'credo' is precisely what has made being a...

There is also some great onformation on:

http://www.sql-server-performance.com/

To be more specific:

http://www.sql-server-performance.com/articles/dev/sql_best_practices_p2.aspx

Here is an odd but true RAID/disk failure story. We had a application server configured with RAID 1 for the OS and such and everything else on the SAN. Well,...