Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Disabling Indexes Expand / Collapse
Author
Message
Posted Thursday, September 09, 2010 9:32 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:47 PM
Points: 1,382, Visits: 1,775
Comments posted to this topic are about the item Disabling Indexes

Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul
Post #983550
Posted Thursday, September 09, 2010 10:47 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
Nice question, thanks!
Post #983555
Posted Thursday, September 09, 2010 11:17 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, November 21, 2013 11:33 PM
Points: 1,481, Visits: 1,959
"ALTER INDEX PK_MyId ON MyTable DISABLE" at this line my brain stopped.

Nice question. Though i think it would have been better if i had stopped at the row above. Since if one didnt know that disabling the clustered index made it impossible to select from the table. You would have selected the 2 row answer anyway.
Post #983560
Posted Thursday, September 09, 2010 11:28 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:40 AM
Points: 3,683, Visits: 4,818
Good question.
shows the dangers of disabling indexes


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #983562
Posted Friday, September 10, 2010 12:59 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 10, 2014 7:08 AM
Points: 3,448, Visits: 4,406
The question would be more educational if it had no 'DROP CONSTRAINT' statement. In this case I would probably have answered wrong
Post #983572
Posted Friday, September 10, 2010 2:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 13, 2014 12:16 AM
Points: 137, Visits: 43
i have checked the same on sql server 2005 on windows server 2003 but i am getting the error message
The query processor is unable to produce a plan because the index 'PK_MyId' on table or view 'MyTable' is disabled.
i think you should check it again.
Post #983602
Posted Friday, September 10, 2010 3:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 2:13 AM
Points: 1,865, Visits: 368
nice one thanks...
Post #983618
Posted Friday, September 10, 2010 3:35 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 2:13 AM
Points: 1,865, Visits: 368
This works on sql 2005... plz. check... you would have commented this line

ALTER TABLE MyTable DROP CONSTRAINT PK_MyId

mukeshkane (9/10/2010)
i have checked the same on sql server 2005 on windows server 2003 but i am getting the error message
The query processor is unable to produce a plan because the index 'PK_MyId' on table or view 'MyTable' is disabled.
i think you should check it again.
Post #983620
Posted Friday, September 10, 2010 3:39 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 11:00 AM
Points: 351, Visits: 876
Fascinating. Thanks
Post #983621
Posted Friday, September 10, 2010 5:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 13, 2014 12:16 AM
Points: 137, Visits: 43
still getting the same error message
Post #983661
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse