Understanding GROUPING and GROUPING_ID Functions in SQL Server
The ROLLUP and CUBE operators are used to return results aggregated by the columns in the GROUP BY...
Different Ways to Compare SQL Server Tables Schema and Data
SQL Server provides us with different solutions to replicate or archive a database table or tables to another database, or the same...
How to Handle Errors in SQL Server Nested Transactions
In this article, we will explore SQL Server Nested Transactions, a transaction block with one or several transactions. The image describes...
The Art of Aggregating Data in SQL from Simple to Sliding Aggregations
Let us start our SQL journey to understand aggregating data in SQL and types of aggregations...
Calculating Running Total with OVER Clause and PARTITION BY Clause in SQL Server
You often come across scenarios where you have to calculate a running total of a quantity. A running total refers to the sum of values in...
SQL Server Table Partitioning and Partitions Tutorial
Problem In this article, we will focus on the demonstration of table partitioning. The simplest explanation of table partitioning can be...
Microsoft SQL Operations Studio: Configuration and Querying
In my previous article, Microsoft SQL Operations Studio: Understanding and Installation, we...
Grouping Data using the OVER and PARTITION BY Functions
The OVER and PARTITION BY functions are both functions used to portion a results set according to specified criteria. This article explains...
SQL Server – Dissect the Internals of sp_spaceused
This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction Understanding the database usage...
SQL Server Trigger: Understanding and Alternatives
The SQL Server trigger is a special type of stored procedures that is automatically executed when...
