From the course: Implementing a Data Warehouse with SQL Server 2022

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Create a data warehouse in SQL Server

Create a data warehouse in SQL Server - SQL Server Tutorial

From the course: Implementing a Data Warehouse with SQL Server 2022

Start my 1-month free trial Buy for my team

Create a data warehouse in SQL Server

“

- [Instructor] A data warehouse is created just like any other database in SQL Server. You'll use the same SQL commands that you're probably already familiar with in order to create the database, build the fact and dimension tables, and join them together with relationships. So let's get started with a new data warehouse here in Management Studio by creating a database for a company called KinetEco. Right-click on the Databases folder and then click New Database. I'll name the database KinetEcoDW. For the row and the log file we could set the size to something larger than the default of eight megabytes if you have an idea about how much space you're going to need. But the autogrowth settings will automatically size files as needed to fit the data. And because the data file will only be growing when the ETL process loads data into the data warehouse, which typically happens overnight we won't have to worry about the files…

Contents