#databases
Read more stories on Hashnode
Articles with this tag
System-Versioned Temporal Tables, also known as History Tables are a built-in feature that keeps track of data changes in SQL Server. Unlike regular...
Intro Database Normalization is a concept & design technique we follow to efficiently organize data and design proper schema, to avoid redundant &...
Recently I had a requirement, wherein I had to import the data from one of the internal applications to the SQL Server for further processing. We had...
PIVOT and UNPIVOT are relational operators for converting table expressions into one another. If we want to turn the unique row values of a column...
SQL Server provides three mechanisms to track data changes in the table objects. This mechanism is also a useful solution for implementing the audit...
A transaction is a group of T-SQL statements performing single or multiple operations on objects as a single unit. If any of the statements in the...
