How to Create Database in SQL Server

Leave a comment (0) Go to comments
How to Create Database in SQL Server youtube Video
Before creating a database, there are several things that must be taken into consideration. • Online Transaction Processing (OLTP) relational databases typically have several users performing transactions at the same time and changing real-time data, so you must determine the likely access patterns of the data and plan to combine frequently accessed data together. • Online Analytical Processing (OLAP) databases require you to take into account the cubes, measures and measure groups, dimensions, attributes, and hierarchies, as well as the perspectives and translations required by your organization. • Collation settings, which include character set, sort order, and other locale specific settings, are fundamental to the structure and function of Microsoft SQL Server databases. When you select a collation for your server or database you are assigning certain characteristics to your data that will affect the results of many operations in your database. • When you design a database, you must first decide the tables that it needs, the type of data that goes in each table, and the users that can access each table.
From:
DBATAG
Views:
18
How to Create Database in SQL Server youtube Video  How to Create Database in SQL Server youtube Video  How to Create Database in SQL Server youtube Video  How to Create Database in SQL Server youtube Video  How to Create Database in SQL Server youtube Video
0
ratings
Time:
03:10
More in
Howto & Style
EOF - How to Create Database in SQL Server, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.