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 Create table TestIndex (id int, somecol varchar(20)) Insert a little bit of data insert into TestIndex […]
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
A while ago (asked Sep 18 at 14:34) I asked a question on StackOverflow. I’m pretty sure I could have found the answer via Google myself but it is so much eaasier to ask someone else to do the work for me and perhaps come up with the better answer.…