SQL SERVER – Enabling Clustered and Non-Clustered Indexes – Interesting Fact | Journey to SQL Authority with Pinal Dave

While playing with Indexes I have found following interesting fact. I did some necessary tests to verify that it is true. When a clustered index is disabled, all the nonclustered indexes on the same tables are auto disabled as well. User do not need to disable non-clustered index separately. However, when clustered index is enabled,… Continue Reading...

Source: SQL SERVER – Enabling Clustered and Non-Clustered Indexes – Interesting Fact | Journey to SQL Authority with Pinal Dave