Viewing 5 posts - 76 through 80 (of 80 total)
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...
February 10, 2011 at 7:06 am
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...
February 10, 2011 at 6:58 am
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...
February 10, 2011 at 6:47 am
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...
February 9, 2011 at 3:03 am
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...
February 2, 2011 at 3:40 am
Viewing 5 posts - 76 through 80 (of 80 total)