Introduction to SQL Server Identity
In this article, we will explore the basics and details of the SQL Server IDENTITY property and the...
Multiple Ways to Delete Duplicates from SQL Tables
Overview This article discusses two different approaches available to remove duplicate rows from SQL table(s) which often becomes difficult...
MERGE: Updating Source and Target Tables Located on Separate Servers
What is the MERGE statement? Using the MERGE statement, we can change data in a target table based on data in a source table. Using it, we...
Moving Existing Table From Primary Filegroup to Different Filegroup
In this article, I am going to explain how to move a table from the Primary filegroup to the...
Exporting Oracle Table to Excel Worksheet
In this article, I will explain how we can divide and export data of an Oracle database table into multiple worksheets of an Excel file...
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...
Performing Data Changes Audit Using Temporal Table
SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using normal...
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...
Creating Dynamic Pivot Table with QUOTENAME Function
In my previous article on the basic pivot operator, we saw how pivot operator could be used to convert rows to columns, resulting in pivot...
Performance of Table Variables in SQL Server
In this article, we are going to touch upon the topic of performance of table variables. In SQL...
