dbcc checkdb
alter database MALL_Test set emergency
ALTER DATABASE MALL_Test SET ONLINE
EXEC sp_dboption 'MALL_Test', 'single user', 'TRUE'
DBCC CHECKDB('MALL_Test',REPAIR_FAST)
DBCC CHECKDB('MALL_Test',REPAIR_REBUILD)
dbcc checkdb('MALL_Test',repair_allow_data_loss)
DBCC CHECKTABLE('Game_PlayLog',REPAIR_ALLOW_DATA_LOSS)
DBCC CHECKTABLE('Game_PlayLog',REPAIR_REBUILD)
EXEC sp_dboption 'MALL_Test', 'single user','FALSE'
ALTER DATABASE Mall_Test SET SINGLE_USER with rollback IMMEDIATE
ALTER INDEX ALL ON Game_PlayLog
REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,STATISTICS_NORECOMPUTE = ON)
DBCC CHECKTABLE('Game_PlayLog',REPAIR_ALLOW_DATA_LOSS)
DBCC CHECKTABLE('Game_PlayLog',REPAIR_REBUILD)
ALTER DATABASE Mall_Test SET MULTI_USER