Disabling Indexes

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 Nakul Vachhrajani » Disabling Indexes

35 posts, Page 4 of 4

«««1 2 3 4

Disabling Indexes

Rate Topic

Display Mode

Topic Options

Author

Message

Paul White

Posted Thursday, September 16, 2010 5:05 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 10,990, Visits: 10,572

As others have said, the question would have been better if the step dropping the constraint had been omitted.

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #987104

Chama

Posted Friday, September 17, 2010 1:46 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 7:20 AM
Points: 134, Visits: 30

Actually it is returned 3 rows and 2 cols..
with started negative value mainvalue

Post #988538

sqllearnings

Posted Thursday, September 30, 2010 12:49 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, January 24, 2013 2:14 AM
Points: 23, Visits: 59

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

Post #996198

Hugo Kornelis

Posted Thursday, September 30, 2010 2:01 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:50 PM
Points: 5,289, Visits: 7,219

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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #996265

Rafael Krisller

Posted Tuesday, June 14, 2011 2:52 PM

Old Hand

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:12 PM
Points: 369, Visits: 165

Interesting!!!

Post #1125343

« Prev Topic | Next Topic »

35 posts, Page 4 of 4

«««1 2 3 4

Permissions