Tag: SQL Advance Concepts

For any programming language, just writing the code is not well enough. It should be written using the best practices for getting optimise performance ....

Performance tuning of a complex SQL query involves understanding its execution flow, optimizing query structure, and improving database interactions. In this article, I will discuss...

This article explain key concepts and best practices related to NULL value in SQL which help in mastering the NULL value in SQL Server....

This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access and breaches....

In SQL Server, Change Data Capture (CDC) is a powerful feature that tracks changes (inserts, updates, and deletes) made to tables, providing detailed information about...

SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax of the After trigger Example...

Replication in SQL Server Introduction Replication in SQL Server is a way of distribution of database and their objects from one master database to one or...

Log Shipping in SQL Server Log Shipping Log Shipping in SQL Server is a process of keeping the latest copy of the database of the...

Rebuild and  Reorganization of Indexes SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert, Delete) in the tables. Over...

Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. This article help in understanding the fragmentation in SQL...