if both servers are running Windows 2008 and have dual gigabit NIC's teamed then you should be able to copy the files in an hour or so

running netbackup with LTO-4...

years ago i went through hell trying to change IP's in a cluster. i wouldn't try anything like on a MS cluster.

your best bet is to test detaching the databases,...

stop using old commands like dbreindex and use new ones like alter index. if you rebuild all your indexes it should also rebuild all your statistics as well

where i work we're on HP and you should be able to do this with Proliant servers. Get a DL 380 with 2-3 P812 RAID controllers. for the storage get...

I saw ANH when i was around 8. It was one of the first movies I saw after coming to the US.

ROTJ I saw when it first came out.

ESB not...

depending on the size of the table and...

string formatting is one of my least favorite things to do. it can take hours to get things right which is a waste of time in my opinion.

which is why...

can you partition a table where you keep say 30-45 days of data. have it partition by day or week to make deletes and inserts faster?

has anyone used SSD's on SQL 2005 on Windows 2003? I just sent for a quote for 4 Proliant DL 380 G7's with 2 of them getting SSD's for tempdb....

it's been about a year now that i've been 100% Steam and lovin it. my oldest son scratched up a few games and i lost some of the discs on...

i've been thinking about it and i think i'm done with desktops. my wife has been bugging me for a Mac, but i don't really want to spend a lot...

could be the backups

i'll try the loop and reschedule to avoid the backup window.

no, always runs. sometimes it runs for hours. and once a month or so it gets stuck to where i have to stop it and delete data manually. i'll start...

this morning's statistics for the column

Statistics for INDEX 'idx_timegen'.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Updated ...

i also have...