Data Model

Data Model

---

Data Model: Entity-Atribute-Value (EAV)

2021-07-23  in Backend / Data Model / T-SQL  tagged Data Model / EAV / T-SQL by Peter Lalovsky

Entity-Atribute-Value (EAV) data model gives us the flexibility to store the data in a way that we have dynamic number of: tables columns in the simplest EAV we have 3 tables: Entity Attribute Value To simplify the understanding of the model we declare: Table Entity holds the list of the […]

---

T-SQL: NVARCHAR(255) vs. NVARCHAR(MAX) Disk Space Comparison

2016-08-04  in Data Model / Database Administration (DBA) / Database Architecture / Database Development / SQL Server / T-SQL  tagged Data Architecture / DBA / Disk Space / T-SQL by Peter Lalovsky

In some scenarios like ETL or load data into a DB, we need to insert the data into a staging table, where all the columns are String data type and on the next step to cleanse and manipulate the data. I heard a discussion about the data type of the […]

---

---