as a former exchange admin, db mail is just a mini smpt client. you just need to point it to one of your internal smtp server and you are good...

i never said it doesn't use RAM over 4GB. it's just not used in everything SQL does. i'm playing with a test server now and doing selects for 8 million...

set statistics io on

your query goes here

set statistics io off

run all three lines and click the messages tab and it will show you the number of reads. or you can...

restore should be enough

yesterday we put one half of our new 64 bit cluster in production. storage is EMC SAN. We attached the disk volumes to the new server, mounted...

at the end of SP2 there is checked checkbox that says run the Vista provisioning tool. something about permissions. if you uncheck it, then it won't run. not sure how...

did you run the provisioning tool at the end of SP2?

the other 4GB is used, but only as a cache from what i remember. most memory functions are still in the first 4GB.

to really use it you have to go...

each core shows up as a separate CPU

i personally can't stand the DTA

i would run a profiler trace and look for queries that do a lot of reads and compare to rows returned. My personal ideal is...

from what i remember it's still 4GB per process and the rest is just for a buffer cache. Pretty much anything memory related is still in the 4GB limit.

We had...

if you are buying new hardware, then make sure you look at 64 bit. Memory is still expensive, but next year it should fall. you can get an Intel box...

unless you are running 64 bit you aren't really using any RAM over 4GB

then try doinog update statistics with fullscan, manually dropping and rebuilding indexes, dropping and rebuilding statistics or any combination of the above

install windows on each node

hook up to common storage

make volume for quorom disk

install cluster on node1

install cluster on node2 and add it to the cluster

run tests to make sure both...

they make changes to user databases as part of the upgrade so there is no going back. i don't think they ever did it with any of their products