Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: How To Setup Windows Authentication

    Thank You Very Much for sharing precious knowledge

  • RE: Index Reorg and Rebuild

    What I have understand You want to see which db need to be re-configure

    or re-build

    run this script

    use master

    SELECT database_id,OBJECT_ID,Index_id,avg_fragmentation_in_percent

    from Sys.dm_db_index_physical_stats (null,null,null,null,null)

    --avg_fragmentation_in_percent if Between 3-5 need Reconfigure

    --Above 30% Rebuild when...

  • RE: Want To Be SQL Server 2008 DBA

    THANK YOU VERY MUCH A THIS IS A LOT FOR ME.

    I AM AT THE RIGHT PLACE.

Viewing 3 posts - 1 through 3 (of 3 total)