Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Indexes   (RSS)

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

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
Posted by vishah | 1 Comments
Filed under:
 
Page view tracker