[2k8] 제약조건 및 인덱스 비활성화/재활성화

/********************************************************************************************
-- Title : [2k8] 제약조건 및 인덱스 비활성화/재활성화
-- Reference : bol, dbrang.tistory.com
-- Key word : check nocheck disable rebuild 활성화 비활성화 재활성화
********************************************************************************************/

-- 제약조건 비활성화
ALTER TABLE Orders
    NOCHECK CONSTRAINT FK_Orders_Customers

ALTER TABLE Orders
    NOCHECK CONSTRAINT ALL;

-- 제약조건 비활성화
ALTER TABLE Orders
    CHECK CONSTRAINT FK_Orders_Customers

ALTER TABLE Orders
    CHECK CONSTRAINT ALL;



-- 인덱스 비활성화
ALTER INDEX PK_Department_DepartmentID ON HumanResources.Department
DISABLE;
GO

ALTER INDEX IX_Employee_OrganizationNode ON HumanResources.Employee
DISABLE;
GO

-- 인덱스 재활성화
ALTER INDEX PK_Department_DepartmentID ON HumanResources.Department
REBUILD;
GO

ALTER INDEX IX_Employee_OrganizationNode ON HumanResources.Employee
REBUILD;
GO