Vipul Shah's SQL Blogs

SQL Server Blogs

Browse by Tags

Related Posts
  • Blog Post: 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 ...
  • Blog Post: 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 done...