Locks are held on [!INCLUDE ssNoVersion] resources, such as rows read or modified during a transaction, to prevent concurrent use of resources by different transactions. For example, if an exclusive ...

G. Moving tempdb to a new location The following example moves tempdb from its current location on the disk to another disk location. Because tempdb is re-created each time the MSSQLSERVER service is ...