XACT_ABORT and Transaction

Specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error. The THROW statement honors SET XACT_ABORT. RAISERROR does not. New applications should use THROW instead of RAISERROR. When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled... » read more

Begin Tran with Error

Transactions are intended to run completely or not at all. The only way to complete a transaction is to commit, any other way will result in a rollback. Therefore, if you begin and then not commit, it will be rolled back on connection close (as the transaction was broken off without marking as complete). As... » read more

Copy Data from PROD to DEV

PROD DB -> Localhost DB -> DEV DB Create database on Localhost On Localhost, create Linked Server to PROD DB Copy data from PROD DB to Localhost DB Once the data is in Localhost, create a SQL backup of the Localhost database Copy the backup file to DEV DB and restore the database to DEV... » read more

Windows Check Disk Space Usage

Settings -> System -> Storage -> Select a Drive Storage Usage will tell you how much space you are using broken up by category. You can also enable “Storage Sense” to automatically free up space by getting rid of files you don’t need, like temporary files and content in your recycle bin.