Forum Replies Created

Viewing 15 posts - 136 through 150 (of 248 total)

  • RE: Index Defragmentation

    GilaMonster (9/13/2010)

    Raghavender (9/13/2010)

    as you can see same index is repeating 2 times on the same table with different fragmentation values.

    So which one we need to take into consideration and if...

    September 13, 2010 at 7:53 am

    #1220052

  • RE: Index Defragmentation

    Here I am repeating my actual question:

    When we have checked the table we can see same index is appearing 2times, and index_level is different. What I observed is the index...

    September 13, 2010 at 5:54 am

    #1219971

  • RE: Index Defragmentation

    Bhuvnesh (9/13/2010)

    Raghavender (9/13/2010)

    - Pages Scanned................................: 32

    it is very small table , you cant expect good defragmentation here , table less then 1000 pages ( as i mentioned in my...

    September 13, 2010 at 5:48 am

    #1219969

  • RE: Index Defragmentation

    Bhuvnesh (9/13/2010)

    Raghavender (9/13/2010)

    can any one please help ?

    POst its result also

    SELECT avg_page_space_used_in_percent

    ,avg_fragmentation_in_percent

    ,index_level

    ,record_count

    ,page_count

    ,fragment_count

    ,avg_record_size_in_bytes

    FROM sys.dm_db_index_physical_stats(DB_ID('Dbname'),OBJECT_ID('MediaService'),NULL,Null, null)

    where index_id in (0,1)

    below is the result:

    NULL 25 0 NULL 32 ...

    September 13, 2010 at 5:46 am

    #1219968

  • RE: Index Defragmentation

    Here is The results:

    DBCC SHOWCONTIG scanning 'MediaService' table...

    Table: 'MediaService' (34099162); index ID: 1, database ID: 5

    TABLE level scan performed.

    - Pages Scanned................................: 32

    - Extents Scanned..............................: 11

    - Extent Switches..............................: 11

    - Avg. Pages...

    September 13, 2010 at 5:02 am

    #1219953

  • RE: Index Defragmentation

    can any one please help ?

    September 13, 2010 at 4:15 am

    #1219934

  • RE: Index Defragmentation

    TheSQLGuru (9/6/2010)

    1) If you create a clustered index on a HEAP table, you won't need to defrag it immediately since it will be as defragged as possible upon creation. ...

    September 7, 2010 at 6:29 am

    #1217267

  • RE: Shrink Log

    homebrew01 (9/6/2010)

    Based on the error message, your database is configured as a publisher for replication. It won't let you truncate the log because replication keeps track of log entries and...

    September 7, 2010 at 3:18 am

    #1217198

  • RE: Backup File Size

    ashish.kuriyal (9/6/2010)

    ohhok, so you have the database but it was never backed up because of thinking on the estimate size it will take? 😀 😀 😀

    you can think that it...

    September 6, 2010 at 7:16 am

    #1216921

  • RE: Introduction to SQL Server Statistics

    can any body please let me know, from where I can get entry code for this Session ?

    September 6, 2010 at 7:10 am

    #1216919

  • RE: Backup File Size

    ashish.kuriyal (9/6/2010)

    try this :-

    SELECT s.database_name,

    m.physical_device_name,

    cast(s.backup_size/1000000 as varchar(14))+' '+'MB' as bkSize,

    CAST (DATEDIFF(second,s.backup_start_date , s.backup_finish_date)AS VARCHAR(4))+' '+'Seconds' TimeTaken,

    s.backup_start_date,

    CASE s.[type]

    WHEN 'D' THEN 'Full'

    WHEN 'I' THEN 'Differential'

    WHEN 'L' THEN...

    September 6, 2010 at 6:49 am

    #1216911

  • RE: Index Defragmentation

    Steve Jones - Editor (9/5/2010)

    You might defrag the index, but you cannot defrag a table without a clustered index. Set one up, then defrag.

    Hi Jones,

    can you please let me know...

    September 5, 2010 at 11:30 pm

    #1216766

  • RE: Index Defragmentation

    prvnrddy-590736 (9/5/2010)

    We have a table called abc and index xyz(Non-Unique,Non-clustered). I need to defrag both the indexes as their fragmentation levels are high. When ever i am running below...

    September 5, 2010 at 8:05 am

    #1216662

  • RE: Drop Down List

    Hi,

    Thanks for your replies, these are very Helpful.

    Thanks Once again.

    September 3, 2010 at 9:26 am

    #1216239

  • RE: Drop Down List

    Stilll no replies, can any body please help me in this ?

    August 24, 2010 at 6:13 am

    #1210949

Viewing 15 posts - 136 through 150 (of 248 total)