agreed, sorry, but probably most DBA's get to maintain/support databases applications they have no control over, I mostly tune third party apps where I can't influence or change design. Getting...

why .. do you think you have a problem?

you install it, there's a nice document included with the download - it's all pretty self explanitory.

with 64 bit sql you the MUST set the max memory for sql server, I'd suggest 1.5 to 2gb below the installed memory.

ANY version on 64bit if you do not...

a raid 5 has to do 4 io for each write :: raid 5 is rubbish for writes. I fail to understand why we constantly post about raid 5 vs...

there can be issues with parallel plans, however, it may be the parallel plan is right, you'll really only know if you view the execution plan for the query.

In some...

If you actually think about what you're asking and what you've posted you'll sort of realise you've both asked a silly question and answered your question < grin >

There is...

well I swear by Idera SQL Server Diagnostic Manager, it costs around £700 per server in uk - negotiable according to number - It's been my right hand for 8...

for 64 bit ent ( I assume std is the same ) you must enable lock pages in memory for the sql service account. You don't need awe enabled. You...

you must set max memory for the sql server, dunno about task manager look in sys.sysperfinfo .. that'll give the real value

select

*

well I have seen backups to network shares, not though the gui. It's not something I like but some sites I've worked use this on a regular basis and for...

no BOL installed then ?

there are lots of reasons - try set options and ansi nulls / quoted ident to start.

having been through a number of studies on consolidation I find that the people/teams producing the plans have no idea on how or what consolidating sql server involves. If you...

your actions for 64 bit are correct. The most important thing is to set a maximum memory setting with 64 bit sql otherwise you end up with no memory and...