for our apps we use db's and tables that are populated with usernames, server, db, login and password

app starts up and checks the db and table for the credentials it...

i...

we've been using EMC's SRDF for years now. we ship the data on a disk level from one SAN to another.

problem now is we have x64 at the main site...

very simple solution, start scheduling maintenance where you need local admin access off hours and the later the better. soon the NT people will give it back to you

when you rebuild an index the statistics are also rebuilt for that index. if you rebuild an index and then run update statistics without a full scan it's the equivelant...

back in the sql 2000 days we used to run dbcc reindex and indexdefrag depending on the frag level and then updating statistics. and we had some strange problems sometimes...

when we had performance problems last year i looked at the schema and the data and approximated that each row of data returned approximately 1MB worth of data. was curious...

we have 2 main db's for billing. one that holds the call records and the other the billing data. the CDR's and other customer data is loaded into the first...

we have some very large customers and when we run bills for them some select queries return anywhere from 1 million to 7 million rows and there is an order...

what problems? we've been using for a year and it's been OK

if it wasn't for 64 bit SQL we would have to go to 64bit Oracle because the kind of...

not sure

i use evault for backups and it comes out in the log how long each step takes. check the app log. should have separate entries for each step of...

check the data in the file against the schema

i'm in telecom as well

we replicate our CDR and billing data via SQL replication and the reporting people have their own databases and grab data from the replicated copies to...

can you check to see if it's the actuall backup of data taking a long time or the truncation of the log? my log backups are supposed to take a...

pretty hard to do since your schema will play a big part in performance

unless there are support problems i would look at x64 hardware and software. HP Proliant DL 380...