I had a bad data disaster recently. When we went to restore from tape, we found that the full backup worked and some of the differentials worked, but...
I have a similar question...wonder if it is even a good idea to do this... I want to set up a database maintenence plan on the warm standby to...
Is there a simple way to do DBCC INDEXDEFRAG on all indexes in the table? Right now, I just have the database maintenence plan set to rebuild the...
Actually, the full text stuff was never set up correctly to begin with...I am in the process of adding timestamp fields to the tables and enabling...
This is SQL Enterprise Server with SP3... This morning, I ran the index tuning wizard on a 12-minute workload I collected yesterday. After about an...
I am attempting to performance audit a SQL 2K, SP3 database server running on a Dell 6400, dual proc, RAID-5, w/2GB physical RAM.<br /><br />I ran...
Separate names with a comma.