How to Create Database in SQL Server
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.
![[Unboxing]C.P. company basic summer items for holiday trip!](https://images.videosashka.com/watch/ChdcmiA7WhE)
