sql 7 is way old now - you might want to make sure the sql service is actually running in the services tab on the server. If it's not and...

so do you have a problem with your current set up? IF not then I'd probably suggest you leave things alone - " if it ain't broke don't fix it"

Reporting...

there must be a clue in there somewhere? Network Management - you need a sql server management/monitoring tool. I use Idera SQL Diagnostic Manager - excellent product. What you monitor...

don't you just love SAN's

renamed 2005 servers - worked the same as 2000, unless I missed something! ( non clustered stand alone servers, no replication, mirroring or such )

I usually install under my own account as a local admin on the box, not using the service account. To date not ever had any errors. Suggest you don't define...

the black box trace may help for the future , but you'd need some way of recording spids vs users. You could ask your users or see if the host...

when you run setup, any version any o/s, it will tell you if it can't install the database engine, it will also prompt you for which parts you wish...

sorry, are all other settings out of the box ?

and you're running the client, management studio, on the actual server?

The use of IN is a red herring and in this case makes no difference to the query. The DTA may well help you but really you need to analyse...

generally the query which takes most % is less efficient. I rarely look at time when tuning, working on io as the most important measure. Once I've sorted the io...

with a small database I'd go for all disks in raid 10 and put all the data files on this array. you need the tlog on a seperate raid 1.

do...

try using the recommended views and not sysprocesses which is a sql 2000 table/view. is this error on the server or the client

aarrgghhh!