/***************************************/ /* GRUMPY PODCAST- CREATING A DATABASE */ /***************************************/ /**************************************/ /* VERSION 1.0 CREATE DATE: 6/17/2020 */ /* CREATED BY: ANGELO R BOBAK */ /**************************************/ /****************************/ /* REVISION HISTORY */ /* REVISION DATE: 6/17/2020 */ /****************************/ /*****************************************/ /* TOPIC 01 - CREATING A DATABASE w/SSMS */ /*****************************************/ /*********************************************/ /* END TOPIC 01 - CREATING A DATABASE w/SSMS */ /*********************************************/ /*****************************************/ /* TOPIC 02 - CREATING A DATABASE w/TSQL */ /*****************************************/ USE [MASTER] GO /*****************************/ /* RUN IN A SEPERATE SESSION */ /*****************************/ /* SP_WHO2 GO ALTER DATABASE ORGANIZATION SET SINGLE_USER GO DROP DATABASE IF EXISTS [ORGANIZATION] GO */ /******************/ /* DO NOT DO THIS */ /******************/ USE MASTER GO -- D:\SQLEXPRESSDATA\ORGANIZATION_BAD CREATE DATABASE [ORGANIZATION_BAD] CONTAINMENT = NONE ON PRIMARY ( NAME = N'ORGANIZATION', FILENAME = N'D:\SQLEXPRESSDATA\ORGANIZATION_BAD\ORGANIZATION_BAD.MDF' , SIZE = 520KB , MAXSIZE = UNLIMITED, FILEGROWTH = 64KB ) LOG ON ( NAME = N'ORGANIZATION_LOG', FILENAME = N'D:\SQLEXPRESSDATA\ORGANIZATION_BAD\ORGANIZATION_BAD_LOG.LDF' , SIZE = 520KB , MAXSIZE = 2000MB , FILEGROWTH = 64KB ) GO USE MASTER GO /*****************************/ /* RUN IN A SEPERATE SESSION */ /*****************************/ /* SP_WHO2 GO ALTER DATABASE ORGANIZATION SET SINGLE_USER GO DROP DATABASE IF EXISTS [ORGANIZATION] GO */ CREATE DATABASE [ORGANIZATION] CONTAINMENT = NONE ON PRIMARY ( NAME = N'ORGANIZATION', FILENAME = N'D:\SQL2019DATAI2\ORGANIZATION\ORGANIZATION.MDF' , SIZE = 520KB , MAXSIZE = UNLIMITED, FILEGROWTH = 64KB ), FILEGROUP [ORGANIZATION_DATA] ( NAME = N'ORGANIZATION_DATA', FILENAME = N'D:\SQL2019DATAI2\ORGANIZATION\ORGANIZATION_DATA.NDF' , SIZE = 1000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 64KB ) LOG ON ( NAME = N'ORGANIZATION_LOG', FILENAME = N'D:\SQL2019DATAI2\ORGANIZATION\ORGANIZATION_LOG.LDF' , SIZE = 520KB , MAXSIZE = 2000MB , FILEGROWTH = 64KB ) GO ALTER DATABASE ORGANIZATION SET SINGLE_USER GO ALTER DATABASE ORGANIZATION ADD FILEGROUP [ORGANIZATION_DATA4] GO ALTER DATABASE ORGANIZATION ADD FILE ( NAME = N'ORGANIZATION_DATA4', FILENAME = N'D:\SQL2019DATAI2\ORGANIZATION\ORGANIZATION_DATA4.NDF' , SIZE = 1000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 64KB ) TO FILEGROUP [ORGANIZATION_DATA4] GO ALTER DATABASE ORGANIZATION ADD FILE ( NAME = N'ORGANIZATION_DATA3', FILENAME = N'D:\SQL2019DATAI2\ORGANIZATION\ORGANIZATION_DATA3.NDF' , SIZE = 1000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 64KB ) TO FILEGROUP [ORGANIZATION_DATA3] GO ALTER DATABASE ORGANIZATION SET MULTI_USER GO /*********************************************/ /* END TOPIC 02 - CREATING A DATABASE w/TSQL */ /*********************************************/ /***********************************/ /* TOPIC 03 - DROPPING A DATABASE */ /***********************************/ SP_WHO2 GO /***************************************/ /* KILL RUNNNING OR BLOCKING PROCESSES */ /***************************************/ /* KILL ?? GO */ ALTER DATABASE [TEST] SET SINGLE_USER; GO DROP DATABASE IF EXISTS [TEST] GO /*************************************************/ /* END TOPIC 03 - DROPPING A DATABASE WITH SSMS */ /*************************************************/