Comments on Renjucool.com - "Life Runs on Code": Index to be recreated in Sql Server

@Helga that can be used, but its not a freeware,if...

2009-12-14T08:17:31.612-08:00

@Helga that can be used, but its not a freeware,if you know about any freeware just please share the info.Thanks for your valuable information.

indexes can be also rebuilt by the microsoft repair mssql base service, maybe this way is easier?

@Jithesh You can use this query to list out the F...

2009-12-11T10:50:17.751-08:00

@Jithesh

You can use this query to list out the Fragmentation level in sql Server

USE AdventureWorks
GO
SELECT object_name(IPS.object_id) AS [TableName],
SI.name AS [IndexName],
IPS.Index_type_desc,
IPS.avg_fragmentation_in_percent,
IPS.avg_fragment_size_in_pages,
IPS.avg_page_space_used_in_percent,
IPS.record_count,
IPS.ghost_record_count,
IPS.fragment_count,
IPS.avg_fragment_size_in_pages
FROM sys.dm_db_index_physical_stats(db_id(N'AdventureWorks'), NULL, NULL, NULL , 'DETAILED') IPS
JOIN sys.tables ST WITH (nolock) ON IPS.object_id = ST.object_id
JOIN sys.indexes SI WITH (nolock) ON IPS.object_id = SI.object_id AND IPS.index_id = SI.index_id
WHERE ST.is_ms_shipped = 0
ORDER BY 1,5
GO

Hi, This may be a dumb question, but do I have an...

2009-12-11T01:43:49.704-08:00

Hi,

This may be a dumb question, but do I have an option to know whether the Fragmentation has grown big..?
Jithesh

How get clustered and non clustered index?

2009-11-18T11:20:07.118-08:00

How get clustered and non clustered index?