Introduction to SQL Server Identity

Database development, Tables

In this article, we will explore the basics and details of the SQL Server IDENTITY property and the...
Read More

Multiple Ways to Delete Duplicates from SQL Tables

Database development, Tables

Overview This article discusses two different approaches available to remove duplicate rows from SQL table(s) which often becomes difficult...
Read More

MERGE: Updating Source and Target Tables Located on Separate Servers

Database development, Statements, Tables

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...
Read More

Moving Existing Table From Primary Filegroup to Different Filegroup

Database development, Tables

In this article, I am going to explain how to move a table from the Primary filegroup to the...
Read More

Exporting Oracle Table to Excel Worksheet

Database administration, Database development, Tables, Work with data

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...
Read More

Different Ways to Compare SQL Server Tables Schema and Data

Database development, Tables, Work with data

SQL Server provides us with different solutions to replicate or archive a database table or tables to another database, or the same...
Read More

Performing Data Changes Audit Using Temporal Table

Database administration, Tables, Work with data

SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using normal...
Read More

SQL Server Table Partitioning and Partitions Tutorial

Database development, Tables

Problem In this article, we will focus on the demonstration of table partitioning. The simplest explanation of table partitioning can be...
Read More

Creating Dynamic Pivot Table with QUOTENAME Function

Database development, Statements, Tables

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...
Read More

Performance of Table Variables in SQL Server

Database administration, Database development, Performance Tuning, Tables

In this article, we are going to touch upon the topic of performance of table variables. In SQL...
Read More
Close