Disabling Indexes - SQL School Video

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Warren » Disabling Indexes - SQL School Video

Disabling Indexes - SQL School Video

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Tuesday, November 25, 2008 10:03 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the item Disabling Indexes - SQL School Video

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #608842

jlamar

Posted Tuesday, January 13, 2009 1:01 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 13, 2009 4:07 PM
Points: 1, Visits: 2

EXCELLENT 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!!

Post #635776

plreeter

Posted Tuesday, January 13, 2009 3:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, August 11, 2010 12:52 PM
Points: 2, Visits: 9

Great 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!

Post #635874

SQLBOT

Posted Tuesday, January 13, 2009 3:42 PM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:22 PM
Points: 626, Visits: 835

I 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

~BOT

Craig Outcalt

Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258

Post #635891

Anipaul

Posted Wednesday, January 14, 2009 8:47 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:50 AM
Points: 4,785, Visits: 1,334

Great Video...:)

Post #636315

GilaMonster

Posted Wednesday, January 14, 2009 9:00 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 37,635, Visits: 29,886

plreeter (1/13/2009)

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?

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 metadata

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #636338

« Prev Topic | Next Topic »

Permissions