dratt - sorry - meant to say essentially what you're doing is what I do, however rank your waits as a %age of the total wait to see if they...

yeah I'd worry about i/o completion, that's one wait type you don't want to see. essentially means slow disk subsystem.

I do worry sometimes !!  Books On Line  make sure you download the latest set from microsoft web site - seems they get monthly updates.

I don't believe std edition can take advantage of the 3gb switch - certainly I never managed to make it do so. A full database dbcc reindex across all tables...

I'll get back to you on this one

Good question which will open a veritable can of worms!!! ( and probably get the most absurd suggestions ) OK , tens of thousands does not make a large table...

Becoming a contractor/consultant rather than an employee can be a good way to reduce stress!! Although I will admit you get a whole load of new factors it does take...

Well technically it's not an unamiguous date - there's a couple of guaranteed dateformats that may work, and you're using a string in place of a date so I can...

This is all covered in BOL.

sql server 2005 comes with an upgrade adisory wizard - run  this against your 2000 databases. DTS is likely to be your biggest conversion problem.

I don't wish to be intentionally rude but if you're asking this question you shouldn't be developing the solution. I believe the asp.net microsoft training course would provide the answers...

I'd suggest you're in between refreshes of the counters. You don't memtion which memory counter you're monitoring. The management views contain a significant amount of information - check out BOL...

you can always get an eval of 2005

There seem to be constant postings about disabling HT which I think has almost reached urban myth status. I've used 2, 4 and 8 way boxes with HT and not...

Yeah and sometimes I think the increasing number of bloggs is actually responsible for more problems then they try to solve. To be blunt a 2Gb std edition is not...