Hello,

I dont know much about DTS but i assume you will be writing the query to select the data....however i have noticed a problem from the table exert you posted....there...

hello,

not sure what recovery model you are using for the databases but if you use SIMPLE mode it will regularly truncate the transaction log....but beware....this will only allow you to...

NEVER put logs onto a RAID5 array....logs only use sequential write activity and RAID5 gives over a 40% drop in performance for writes....RAID1 or RAID10 is the only type to...

i have been struggling with this topic for a while....i have a slightly different issue where i am limited by spindles....but the theory is the same

one thing i have found...

you can use something similar to this to get the index names to rebuild

select a.[object_id], b.name from sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) a

join sys.objects b on a.[object_id]=b.[object_id]

where index_id=2 and avg_fragmentation_in_percent...