ALTER DATABASE DWH
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO

DBCC CHECKDB

--DBCC CHECKDB (DWH, repair_allow_data_loss) WITH NO_INFOMSGS 

GO

ALTER DATABASE DWH
SET MULTI_USER;