Microsoft SQL Server 2012 finally release. There are three main version:

• Microsoft SQL Server 2012 Enterprise Edition
• Microsoft SQL Server 2012 Business Intelligence Edition
• Microsoft SQL Server 2012 Standard Edition

For more information, please go to http://www.microsoft.com/sqlserver/en/us/editions.aspx

Microsoft SQL Server 2012 innstallation step by step

 The “CREATE DATABASE <Database Name>” will impact to database performance issue  if it’s not utilize properly.

There are many articles has discussed and posted.

I would recommend to issues a complete a statement instead of CREATE DATABASE <Database Name> :

CREATE DATABASE BearCreek ONPRIMARY

(NAME =N’BearCreek_Data’,FILENAME=N’M:\SQL_Data\BearCreek.mdf’,

SIZE= 8MB, MAXSIZE =UNLIMITED, FILEGROWTH = 16MB),

FILEGROUP FG1

(NAME =N’BearCreek_Data2′,FILENAME=N’M:\SQL_Data\BearCreek.ndf’,

SIZE= 8MB, MAXSIZE =UNLIMITED, FILEGROWTH = 16GB),

FILEGROUP BearCreekDocuments

CONTAINSFILESTREAMDEFAULT

(NAME =N’BearCreekDocuments’,FILENAME=N’M:\SQL_Data\BearCreekDocuments’)

LOG ON

(NAME =N’BearCreek_Log’,FILENAME=‘L:\SQL_Log\BearCreek.ldf’,

SIZE= 8MB, MAXSIZE =UNLIMITED, FILEGROWTH = 16MB)

GO

ALTER DATABASE BearCreek

MODIFY FILEGROUP FG1

DEFAULT

GO