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 16, 2010 5:05 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, November 20, 2014 7:53 PM
Points: 9,928, Visits: 11,194
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
Posted Friday, September 17, 2010 1:46 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, August 12, 2013 2:07 PM
Points: 168, Visits: 38
Actually it is returned 3 rows and 2 cols..
with started negative value mainvalue
Post #988538
Posted Thursday, September 30, 2010 12:49 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 9:46 AM
Points: 79, Visits: 103
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
Posted Thursday, September 30, 2010 2:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 3:56 PM
Points: 6,086, Visits: 8,354
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
Posted Tuesday, June 14, 2011 2:52 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:09 AM
Points: 395, Visits: 168
Interesting!!!
Post #1125343
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse