Forum Replies Created

Viewing 5 posts - 361 through 365 (of 365 total)

  • RE: Exclude the Index Reorganize logic

    hi,

    Its working fine after excluding reorganize logic. But I'm running this script for each database one-by-one manually connecting each db. Could you tell me what & where should I add...

  • RE: Exclude the Index Reorganize logic

    Hi Gail,

    http://msdn.microsoft.com/en-us/library/ee308910%28BTS.10%29.aspx

    From the above Microsoft link:

    Default Settings for the Database Index Rebuilds and Defragmentation

    BizTalk Server does not support defragmenting indexes. “DBCC INDEXDEFRAG” and “ALTER INDEX … REORGANIZE …”...

  • RE: index fragmentation for Share point Content database

    http://msdn.microsoft.com/en-us/library/ms175008.aspx

    I have used script listed on this page but i have modified it to replace cursor and run it for all databases in production server rather than just one database.

    I'm...

  • RE: Transactional Replication

    I have ran this query in a database "DB_Name" and its returning the tables related to some other database in the same instance.

    But how can we check whether all...

  • RE: Index fragmentation

    I found the below script from MSDN for index deframentation:

    avg_fragmentation_in_percent 30 ---do index rebuild

    Can I schedule this to run every day after business hours?

    -- Ensure a USE ...

Viewing 5 posts - 361 through 365 (of 365 total)