HOW DO I IMPLEMENT THIS CONDITION @ the db level, where STATUS , STATUSDate are columns of a table test.
that if STATUS = 1 the STATUSDate cannot be...
i used the LIMITED mode for sys.dm_db_index_physical_stats.
there are no text or ntext column.
There are 3 indexes on the tables. they are
nonclustered located on PRIMARY
clustered, unique, primary key located on PRIMARY
well i used sys.dm_db_index_physical_stats instead
database_id object_id indexe_id partition_number alloc_unit_type_desc index_depth index_level...
As per BOL for 2005 i tried to defrag indexes by both methods
1.reorganizing an index
2.rebuilding an index
but still some of my tables indexes...
Separate names with a comma.