----------------------------------------------------------------
--                                                              
--  File:   Database_Options_1.SQL                              
--          Microsoft TPC-E Benchmark Kit Ver. 1.14.0-1031      
--          Copyright Microsoft, 2008-2015                  
--                                                              
----------------------------------------------------------------

USE master
GO

ALTER   DATABASE tpce
SET     RECOVERY BULK_LOGGED
GO

ALTER   DATABASE tpce
SET     TORN_PAGE_DETECTION OFF
GO

ALTER   DATABASE tpce
SET     AUTO_CREATE_STATISTICS ON
GO

ALTER   DATABASE tpce
SET     AUTO_UPDATE_STATISTICS ON
GO

ALTER   DATABASE tpce
SET     PAGE_VERIFY NONE
GO

ALTER   DATABASE tpce
SET     ALLOW_SNAPSHOT_ISOLATION ON
GO

-- set show advanced options to 1 so we get all the available options
sp_configure    'Show advanced options',1
GO

-- reconfigure the server so the show advanced option will take effect
RECONFIGURE WITH OVERRIDE
GO

-- set the MAX Degree of Parallelism to 0 for the load
sp_configure    'max degree of parallelism',0
GO

-- reconfigure the server so the MAXDOP will take effect
RECONFIGURE WITH OVERRIDE
GO

USE tpce
GO

CHECKPOINT
GO




