I'd isolate the web and sql to seperate boxes - putting them together is not a good solution for either performance or security.

As to the rest it depends upon the...

All of this is good but many suggestions would struggle with say 60 servers to manage.

In General the DBA has to define what is right for their environment - defining...

Sounds unlikely to me, however, I'd look to make sure things like auto close are off.

You might note that some maint options will put the database into single user  so...

I usually update stats every night. I generally turn off auto-update stats preferring to manually update them, my thinking is that if stats do need updating automatically there's probably a...

As far as I know you cannot restore a 2k backup into 7.0 - sadly I don't have a 7.0 version to test. The only way it might work is...

Although multiple filegroups on a single array may prove detrimental.

W2003 should have the PAE enabled by default, however you might need to check with your platform support/ see how much memory is reported in sysperfinfo or the sql error...

sqlservr.exe -c -m  ( from the appropriate directory )

use master

go

restore database master from tape = '\\.Tape0'

from disk file='xxxx.bak'

It's in BOL - just follow the instructions.

You actually have a covered index which can often perform equally with a clustered index, you might want to examine your i/o count however, often using a nc index will...

When you change the database collation it does not recollate the existing objects.

To recollate a database the safest method is to create a copy of your database to be...

For one you'll have a job that most ( including many IT ) people will never understand and will have fallen asleep before you finish explaining

I'm...

run this:-

select * from master.dbo.sysperfinfo where counter_name like '%server memory%'

The two figures show the memory available and the memory sql server will/does use. In general you wouldn't really use more...

When you set the max cpu's for sql server it limites sql server to this number of processors, "everything else" can still use all the procs if "everything else" is...

exec dbo.sp_configure 'min server memory',3072

exec dbo.sp_configure 'max server memory',3072

exec dbo.sp_configure 'awe enabled',1

reconfigure with override

go

The counters are updated in real time in sysperfinfo. You do need to check out how to extract the information and the format/method in which it is stored.

There were...