sql A is your source 2000 server

SQL B is the final 2005 server

test SQL is your temp server.

create empty databases on testSQL with the same names as on SQL...

cool, but it's a lot easier done with iphones and android phones. and without the need to keep your home computer on 24/7

how many rows are you inserting? could be page splitting, triggers, etc

we had this when we first went to 64bit. it wasn't in any documentation, but a blog posting by one of the db engine developers. the max memory didn't work...

i have a process where i dump the backupset tables to a central database and then i have SSRS reports email me this daily.

my guess would be yes since if you have auto update stats enabled it's going to do it twice

did you configure lock pages in memory?

any reason why you can't create additional files and put data there as well?

does anyone still use myspace?

i read the summary and facebook gets a lot more density per server with the noSQL version they are using. I think it's Hadoop, but not...

depends on your SAN and disk configuration. i've seen alter index times go from 10 minutes to 30 minutes on a table on the same SAN just on a different...

this will depend on the vendor. i believe with EMC you can assign specific drives as you want. Netapp everything is a RAID5 or 6 or something similar and you...

good luck, i've read that most social sites are designed for use on noSQL databases

back when we did this what i did was create dummy databases on a test server with the same names as production. then saved all my DTS's there. and then...

had AMD for my last build, but the lack of 32nm is not making me happy. by the time AMD goes to 32nm Intel will be on Ivy Bridge and...

if you haven't heard, Intel just announced a recall of almost all Sandy Bridge Intel chipsets