I struggle with the concept of a relational database with primary keys - an identity column does not replicate either, as such. remember a primary key does not have to...

backups can slow performance, my preferred route always for backups is thus:-

• Backup to fast dedicated disk using native or compressed ( litespeed etc. )
• copy backup to backup repository , essentially...

an indexed view materialises the data so doesn't save space.

The basic answer is to test and see - I generally don't have much time for views as they will often...

the trouble with update in place is that all the previous version files are left there too. works same with o/s just not a good idea - you can imagine...

network backup is your issue - backup to fast local disk ( or local san ) . more spindles and raid 10 will give performance. I can't give exacts because...

ah you should have mentioned Tivoli - a monitoring application of little value with lots of stupid alerts and counters set by ( persumably ) people who know nothing about...

http://www.amazon.co.uk/Server-Performance-Tuning-Technical-Reference/dp/0735612706/ref=pd_sim_b_2/202-6289704-7140657

I have always regarded this as the best place to start.

For sql 2005 there is no one book, not any more. The inside books are good. You really need...

If you're going to compare raid 5 and raid 10 then you must compare to the number of available disks not changing the same number of disks, so 20 disks...

the bookmark lookup still exists in sql 2005. Views are rubbish like you describe, you might want to try table valued function.

I've found that joining views or joining to views...

why don't you add some disks and split the DW database to a seperate array?

Query governor is more trouble than it's worth. Better to train your developers.

I did an upgrade in place once, never again.  Use it as a way to upgrade your databases if you wish, but then get a new clean sql 2005 install...

you must fix maximum memory on 64bit sql server otherwise you will have real problems.

As Markus says you must also update stats and I'd suggest rebuild all indexes and run...

please read BOL, a good sql book or attend a training course. This is how it should be, get familiar with the basics of sql server - this post, which...

off the top of my head the difference could be due to block size of the disks. It's possible that 64bit values may be larger than 32 bit values giving...

if sql is using awe you can't use task manager  to view memory usage.

I don't have a full running 64 bit to hand to check but I'm still sure that...