MS SQL Server 2012 How-to - Creating Database Objects in MS SQL Server 2012 - Part 1/5
https://sqlserver2014tutorial.com/
In this MS SQL Server 2012 training video series, we cover database objects and how to create them. A database object is any defined object in a database that is used to store or reference data. Some examples of database objects include tables, views, clusters, sequences, indexes, and synonyms.
You can create a database or object through Microsoft SQL Server Management Studio (SSMS), Transact SQL (TSQL) or the Template Browser.
In this part (1 of 5), we look at and demonstrate creating a database using SSMS. This is the easiest method of database creation. Some considerations using this method:
Database objects should be named intuitively and without spaces
The Data file and Log file should be stored on separate drives for performance reasons (one is primarily written to while the other is primarily read)
For a Production database, set the recovery option to ‘Full’
‘Auto Growth’ should be set to ‘MB’ instead of ‘%’
Please subscribe to our channel and like our videos! We have many training videos on MS SQL 2012
Visit our other sites:
https://www.learningcomputer.com
https://datatechnologyllc.com
https://sqlserver2014tutorial.com/