well you just need a dedicated pipe, pipes run at similar speed to your network, therfore a 10mb pipe will run at 10% of 100mb ethernet or 100th of a...

Very very very important - NOT filegroups, files. For any database, not just tempdb, you may gain performance by having the same number of files per filegroup as you have...

/3gb and allocated memory to 7gb out of 8gb is not a good idea. You will need to check available memory but I'd say 6gb would be top. You can...

you realise sql2k goes out of support next year?  8 instances on 8gb ram means you can only allocate 750mb to each instance unless you want anachy and the chance...

creating un-needed keys or parts of keys, presumably for 16 bytes we're talking guid's, will increase the width of keys and indexes for no purpose, increase storage size and degrade...

I think you're missing the point, what you're asking for is application monitoring for your particular application - only the application writers can do that or you could modify your...

what you should always consider is that log shipping, transactional replication and mirroring do not provide the same thing.  You have to consider the reasons you want to have a...

It makes little point to stay with 32bit, it's old technology. However if you have vendor apps then you'll probably need to kick them hard to upgrade to 64bit - I...

if you connect to the database engine in management studio it will show the patch/sp level

I'd suggest you re-install if the version is incorrect.

there seems to be just so much confusion over memory settings on sql server :-

to see exactly what memory is being used run this query

select