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 nonclustered located...
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.
