Disabling Indexes

  • Actually it is returned 3 rows and 2 cols..

    with started negative value mainvalue

  • 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??

  • :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/

  • Interesting!!!

Viewing 4 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply