Dimensional modeling in Data Warehouse: An Ultimate Magical Guide (Part 1)

data warehouse

Dimensional Modeling Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data warehouse. The purpose of dimensional modeling is to optimize the database for faster retrieval of data. A dimensional model in data warehouse is designed to read, summarize, analyze numeric information like values, balances, counts, weights, etc. In contrast, relation … Read more

In-Memory OLTP SQL Server Secrets: Do You Really Need It?

sql server filegroup

When SQL Server 2014 was launched in April 2014, it brought with it a much talked about bonus. Alongside the standard relational engine and its traditional disk-based tables, SQL Server 2014 includes In-Memory OLTP, a high performance, memory-optimized engine that allows users to create data in memory-optimized tables that reside permanently in-memory. This is not … Read more

Discover SQL Server Filegroup Separation Secrets: What and Why?

sql server filegroup

The default settings in SQL Server are not always the best. Such is the case when we are working with new user databases; usually we get a single data (*.mdf) and transaction log (*.ldf) file. The data file resides within the PRIMARY file group; the only one we have so far, and it will store … Read more