There are certain operations where dropping an index, loading data and then again creating the index can speed up data loading. SQL server 2005 introduced a way to disable an index. Let’s take a look, first create this table T-SQL1 Create table TestIndex (id int, somecol varchar(20)) Create table TestIndex (id int, somecol varchar(20)) Insert […]