database design

SQL Server Table Variables Overview

In the article, we are going to explore the basics of SQL Server table variables, compare local temporary table vs global temporary vs table variable, and examine a query execution plan performed with dbForge Studio for SQL Server.

(more…)

Database Reverse Engineering

In our fast-changing world, observations of certain events, operations, and processes determine the development of business and implementation of any solutions or ideas. Such observations are captured in the form of data usually stored and processed in a database.

(more…)

SQL Database Design Basics with Examples

It is a common practice that a DB architect has to design a relational database tailored to a particular solution.

(more…)