How to Create a database with proper configuration ?

• pre size the data file and auto growth property of the data file
• pre size the log file and auto growth property of the log file
• have each data and transaction log file on its own physical drive
• sizing based on the activity that your environment uses
• base your size roughly on two or three years of growth patterns

USE master
GO

CREATE DATABASE [Production]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N’Production2′, 
FILENAME = N’C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAProduction.mdf’ , –<< this must be in its own physical drive>>

SIZE = 5MB , –<< pre size the data file 5000 mb
FILEGROWTH = 1MB )  –<< pre size the log file 100 mb>>

 LOG ON 
( NAME = N’Production2_log’, 
FILENAME = N’C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAProduction_log.ldf’ , –<< this must be in its own physical drive>>

SIZE = 1MB , –<< pre size size of transaction log file 100 mb
FILEGROWTH = 1MB ) –<< pre size size auto growth to increase in increments of 5 mb>>
GO