Temporal Table feature overview SQL Server 2016 introduced database feature that brings support for providing information about tracking the history of records processed with Create/Update/Delete operations. This is quite often business demand in enterprise applications. So far it was realized in several ways: Creating Created, Updated columns in a table Creating a history table for… Read More

If you think you never had encounter window functions, maybe you remember the question from an interview: What’s difference between GROUP BY and PARTITION BY. Think is that PARTITION BY is one of many window functions. Ok, so let’s start with the difference between GROUP BY and PARTITION BY. Understanding¬†window functions concept Let’s consider stored… Read More