Generating Scripts only for Clustered and Non-Clustered indexes in SQL Server 2005

In following cases you will need to generate a scripts for all the clustered and non-clustered indexes on the SQL Server 2005 database: 1. During heavy bulk inserts into a table, you might want to drop all the indexes on the table to make the bulk load process go faster.  Once the bulk load is…

0

Indexing a SQL Table

I found one of my old documents where I kind of summarized Indexes on a SQL Table, might help.  Indexing SQL Table   Primary Key: ·         Creates clustered index on the column ·         Doesn’t allow NULLS     Unique Key: ·         Creates non-clustered index on the column ·         Allows only one NULL     Index…

1