{ SORT_IN_TEMPDB = { ON | OFF } | MAXDOP = max_degree_of_parallelism | DATA_COMPRESSION = { NONE | ROW | PAGE | COLUMNSTORE | COLUMNSTORE_ARCHIVE} } | ONLINE = { ON [( <low_priority_lock_wait> ) ] | OFF } } <low_priority_lock_wait>::= { WAIT_AT_LOW_PRIORITY ( MAX_...
This is the default value for TempDB. <filegroup_updatability_option>::= Sets the read-only or read/write property to the filegroup. READ_ONLY | READONLY Specifies the filegroup is read-only. Updates to objects in it are not allowed. The primary filegroup cannot be made read-only. To ch...
This is the default value for TempDB. <filegroup_updatability_option>::= Sets the read-only or read/write property to the filegroup. READ_ONLY | READONLY Specifies the filegroup is read-only. Updates to objects in it are not allowed. The primary filegroup cannot be made read-onl...
To move a data file or log file to a new location, specify the current logical file name in the NAME clause and specify the new path and operating system file name in the FILENAME clause. For example: Copy MODIFY FILE ( NAME = logical_file_name, FILENAME = ' new_path/os_file_name...
This is the default value for TempDB. <filegroup_updatability_option>::= Sets the read-only or read/write property to the filegroup. READ_ONLY | READONLY Specifies the filegroup is read-only. Updates to objects in it are not allowed. The primary filegroup cannot be made read-only...
{ SORT_IN_TEMPDB = { ON | OFF } | MAXDOP = max_degree_of_parallelism | DATA_COMPRESSION = { NONE | ROW | PAGE | COLUMNSTORE | COLUMNSTORE_ARCHIVE} } | ONLINE = { ON [( <low_priority_lock_wait> ) ] | OFF } } <low_priority_lock_wait>::= { WAIT_AT_LOW_PRIORITY ( MAX_...
When combined with TEMPDB_METADATA = ON, specifies the user-defined resource pool that should be used for tempdb. If not specified, tempdb will use the default pool. The pool must already exist. If the pool is not available when the service is restarted, tempdb will use the default pool....
{ SORT_IN_TEMPDB = { ON | OFF } | MAXDOP = max_degree_of_parallelism | DATA_COMPRESSION = { NONE | ROW | PAGE | COLUMNSTORE | COLUMNSTORE_ARCHIVE} } | ONLINE = { ON [( <low_priority_lock_wait> ) ] | OFF } } <low_priority_lock_wait>::= { WAIT_AT_LOW_PRIORITY ( MAX_...
To set this option, requires membership in thesysadminfixed server role. The DB_CHAINING option cannot be set on these system databases:master,model, andtempdb. The status of this option can be determined by examining theis_db_chaining_oncolumn in thesys.databasescatalog view. ...
To set this option, requires membership in thesysadminfixed server role. The DB_CHAINING option cannot be set on these system databases:master,model, andtempdb. The status of this option can be determined by examining theis_db_chaining_oncolumn in thesys.databasescatalog view. ...