is it really faster? i did some profiler tracing of a small db that is 99% inserts before and after putting indexes on a table. pretty much no difference at...

best way to do this is to write a script to manually move data to your archive database everyday or on whatever schedule

bump

other than mirroring i would love to find a way to run a SP with no downtime. SP2 is pretty nice in that you don't need to run it on...

how long is forever and what is your backup infrastructure like? in my case a 70GB db restore will take 4-6 hours or as long as 12-16 hours.

depends on the query

also look into completely dropping and recreating some indexes. we had one query where MS said they changed the optimizer because it caused a lot of problems...

we do periodic restores to dev/qa servers and it still doesn't keep people out. in this case it turned to be a last minute feature that no one knew about...

HP just started selling the Proliant DL 580 G5. 4 CPU, 256 GB RAM max, 16 HD's max

what is your execution plan saying?

don't tell MS and don't fire any of your IT people so they won't suddenly get an urge to come forward to the BSA or MS

with 64 bit sql 2005 standard will support ludicrous amounts of memory. the only real differences are online indexing and a few other features that you need in a 24x7...

do you have the correct instance specified?

had a similar issue but different error message. check the KB for a hotfix and call MS. this is most likely a Windows issue and not SQL related

so far this has happened only one one server. it's a clustered instance. both nodes. funny thing is that when i first saw this we had 2 instances on the...

when our cluster failed over, the other node picked up that instance. the sql binaries are installed on a shared SAN drive in a cluster so when the other physical...

what's wrong with linked servers?

the 50GB is only for the initial snapshot if you replicate all the tables. after that it's only the changes replicated. we replicate tables to a...