try turning off parallelism or force it to 1 CPU

otherwise how is your IO? The TCP benchmarks are split across dozens of spindles and no one ever does it like...

in ssis i believe there is a qualifier option for quotation marks

i haven't had time to do a trace, but we went back to sp's for replication and it went away even though we had problems with sp's before. we ran...

yes and we did it with full scan last night and still same result. we changed it to use temp tables as a hotfix, but would like to know why...

we had a similar issue. i think it helps if you run maintenance on a regular basis and after a few days the indexes get to a good state

buy as much as you can get. we set up a new distributor a few months back and had to upgrade to 4GB. called MS on an issue and if...

check your c:\winnt\registration folder security properties. WU messes them up

i would stay away from Itanium and just go x64 for 64 bit

we run it under the domain admin account. it's not the best for security, but it's been like that for years and unfortunately we will have to change it soon.

my senior dba found one big all in one script here in the script database but it didn't work too well. i played around with the online script for a...

fragmentation will result in index seeks turning into index scans or worse table scans.

use management studio to connect to all the servers including the sql2k ones and do it all from there. otherwise it's the same process as sql 2000

i'm using Netbackup 5.1 with MP5. when we started testing it last year i read that MP5 is the minimum for SQL 2005 support. At first we were scared we...

i personally don't trust Veritas to do anything except backup the db

i believe the cab files are compressed files that have a lot of other files in them, kind of like a zip file.

have you tried to copy all the files...