In this video you will learn how to create database using SQL Server Management Studio as well as using T-SQL script. You will learn some of the best practices of creating SQL Server Databases and learn some of the important database options to consider while creating SQL Server Databases.
Scripts used in this video
USE [master]
GO
/****** Object: Database [SalesOrders] ******/
CREATE DATABASE [SalesOrders]
CONTAINMENT = NONE
ON PRIMARY ( NAME = N'SalesOrders',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\DATA\SalesOrders.mdf' ,
SIZE = 2048KB , MAXSIZE =UNLIMITED, FILEGROWTH = 1024KB )
LOG ON ( NAME = N'SalesOrders_log',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\DATA\SalesOrders.ldf' ,
SIZE = 1024KB , MAXSIZE =2048MB ,
FILEGROWTH = 10%)
GO
Scripts used in this video
USE [master]
GO
/****** Object: Database [SalesOrders] ******/
CREATE DATABASE [SalesOrders]
CONTAINMENT = NONE
ON PRIMARY ( NAME = N'SalesOrders',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\DATA\SalesOrders.mdf' ,
SIZE = 2048KB , MAXSIZE =UNLIMITED, FILEGROWTH = 1024KB )
LOG ON ( NAME = N'SalesOrders_log',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\DATA\SalesOrders.ldf' ,
SIZE = 1024KB , MAXSIZE =2048MB ,
FILEGROWTH = 10%)
GO
How to Create Database in SQL Server 2014
Hi Sir,
ReplyDeleteCreateDB_Options query is not mentioned here as you have shown in tutorial video. Can you please make it available for the same?
And your each tutorial awesome sir.
CreateDB_Options query is not mentioned here
DeleteCreateDB_Options query is not mentioned here
ReplyDeletemort patiente clinique pasteur
ReplyDeleteidealmed raté
ReplyDeleteNice article. Agree, thanks for sharing. I'm sure others will benefit from it too 789betting vip
ReplyDeleteHello there i read your article and followed as you said and it works for me thank you for this information
ReplyDeletedisawar app development
satta king development
online matka app development
best matka app development
https://gomatkapro.co
You did an excellent job on this post! its very helpful for all of us
ReplyDeletesatta matka result website development
satta king development
online matka app development
best matka app development
https://gomatkapro.plus
This blog is really amazing and very productive. This content has provided me with lots of useful information
ReplyDeleteonline matka development
satta king development
online matka app development
best matka app development
https://gomatka.co
Excellent information
ReplyDeleteThanks you so much for this wonderful article
you written it looks great an unique.
gomatkaplus
Starline games
satta tv
satta tv
Satta king
Sattamatka
Sattaking
https://sattaking.chat
we are proud of you
ReplyDeleteyou did great job
we wish you best of life
very interesting, good job, and thanks for sharing such a good blog. 123bet vip
ReplyDelete