Disabling Indexes

• Chama

  SSC Enthusiast

  Points: 198

  More actions

  September 17, 2010 at 1:46 pm

  #1223303

  Actually it is returned 3 rows and 2 cols..

  with started negative value mainvalue

• sqllearnings

  SSC Journeyman

  Points: 83

  More actions

  September 30, 2010 at 12:49 pm

  #1229838

  Sorry if I am mistaken. I never tried this out but as per the MSDN article

  http://msdn.microsoft.com/en-us/library/ms177456.aspx it says this

  The data rows of the disabled clustered index cannot be accessed except to drop or rebuild the clustered index. This means the following:

  These operations will fail: SELECT, UPDATE, DELETE, INSERT, CREATE INDEX, CREATE STATISTICS, UPDATE STATISTICS (on the index), and ALTER TABLE statements that modify table columns or constraints.

  So in that case, wont the statement fail when we try to alter the table to drop the constraint??

• Hugo Kornelis

  SSC Guru

  Points: 64790

  More actions

  September 30, 2010 at 2:01 pm

  #1229897

  :laugh: Good catch, Ashwin. I think the documentation needs to be expanded to list dropping the constraint as an exception to this rule. Maybe you can submit this as a documentation bug?

  ---

  Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
  Visit my SQL Server blog: https://sqlserverfast.com/blog/
  SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/
  

• Rafael Krisller

  Right there with Babe

  Points: 737

  More actions

  June 14, 2011 at 2:52 pm

  #1338672

  Interesting!!!