SQLServerCentral / Discuss Content Posted by Andy Warren / Article Discussions / Article Discussions by Author / Disabling Indexes - SQL School Video / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 20:17:55 GMT20RE: Disabling Indexes - SQL School Videohttp://www.sqlservercentral.com/Forums/Topic608842-29-1.aspx[quote][b]plreeter (1/13/2009)[/b][hr]Does anyone know if disabling the indexes and rebuilding them after the bulk insert is a more efficient method than dropping the indexes and recreating them after the insert?[/quote]It'll be the same. The index b-tree still needs to be built in both cases. The only difference between disabled and dropped is that disabled doesn't remove the metadataWed, 14 Jan 2009 09:00:14 GMTGilaMonsterRE: Disabling Indexes - SQL School Videohttp://www.sqlservercentral.com/Forums/Topic608842-29-1.aspxGreat Video...:)Wed, 14 Jan 2009 08:47:44 GMTAnipaulRE: Disabling Indexes - SQL School Videohttp://www.sqlservercentral.com/Forums/Topic608842-29-1.aspxI don't think there would be much difference, as behind the scenes you essentially have a lock, logged page deallocation, and index build + logging in both cases.Best way is to try it and see. At the very least you'll be happy to lose all that DDL code you've been using in your existing process. :D~BOTTue, 13 Jan 2009 15:42:02 GMTSQLBOTRE: Disabling Indexes - SQL School Videohttp://www.sqlservercentral.com/Forums/Topic608842-29-1.aspxGreat video!Does anyone know if disabling the indexes and rebuilding them after the bulk insert is a more efficient method than dropping the indexes and recreating them after the insert?I'm loading several million rows and with the drop/create method it takes up to 5 hours to recreate the indexes. Thank you!Tue, 13 Jan 2009 15:23:54 GMTplreeterRE: Disabling Indexes - SQL School Videohttp://www.sqlservercentral.com/Forums/Topic608842-29-1.aspxEXCELLENT video presentation! The speed of the presenter, both in speech, and in demonstration was tremendous! Especially the parts where he would give simple reminders, of what he's covered, to keep everyone up to speed. Good job!!Tue, 13 Jan 2009 13:01:22 GMTjlamarDisabling Indexes - SQL School Videohttp://www.sqlservercentral.com/Forums/Topic608842-29-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Video/65080/">Disabling Indexes - SQL School Video</A>[/B]Tue, 25 Nov 2008 22:03:16 GMTAndy Warren