Forum Replies Created

Viewing 3 posts - 16 through 18 (of 18 total)

  • RE: DBCC SHOWCONTIG took over 4 hours!

    Changing to the bulk-logged recovery model will reduce the amount of tran log used if you use DBCC DBREINDEX, but not if you use DBCC INDEXDEFRAG. Be aware that although...

  • RE: Replication error

    I'm just guessing here, but you might verify that the publishing server has a record in sysservers on the distributor SQL Server.

  • RE: DBCC SHOWCONTIG took over 4 hours!

    I tend to use the FAST option. Although it doesn't give me as much detail as not using it, I get all the information I need to determine whether an...

Viewing 3 posts - 16 through 18 (of 18 total)