I think you may have other problems. You may want to have as much memory as the size of your databases + some for tempdb - it all depends upon...

you can indeed do partial restores etc. It's been a while since I did this - you might want to search what paul Randal has blogged about it. When...

I just noticed you mentioned SAS - watch out for sata drives in your SAS trays! Sata and sas drives spin slower usually 7.2k and 10k this decreases response...

welcome to the world of vendor bull ****. Shared luns are the biggest causes of performance issues on a san for sql server. Just think about what you're...

it's so difficult to generalise but I believe the figure of 5,000 context switches per processor ( core ) is considered a reasonable figure.

If you have hyperthreading then you should...

you can't just pick a value for context switches, it all depends upon the number of procs, workers and workload.

On what basis do you feel you need to make this...

I never understand why it's assummed that a simple query from a view ( which is probably complex ) will work well. Forget your views and expand the query into...

you do want to go 64bit, forget x32. As for the rest I agree with Steve it's just difficult to know. I will disagree about NIC's there should never...

umm - I don't want to be picky here but I actually said the DBA needs to be sysadmin and also a member of the local administrators group - nowhere...

this is a subject which is raised every so often - usually by auditors, suits or bean counters, none of whom understand databases, technology or our/your business.

I have a numbe...

a delete trigger linked to dbmail or smtp mail ( search the site for procs which send smtp mail ) should do the trick - or write the deleted...

you need to define o/s, versions, editions, db sizes, hardware details and more before anyone could make much more than a guess.

I'd really suggest you find someone who has experience in this sort of thing. However, as with any process it is determined by your business requirement and the staff you...

unresolved as yet - I will blog about it this weekend and see if it gets a suggestion - I asked at a user group meeting but no-one had any...

if the page is there , clean or dirty, it's still in cache. I did look at the dirty pages but technically a checkpoint should have flushed them, add to...