Understanding Estimated and Actual Query Plans in SQL Server
An estimated query plan is a prediction based on available statistics whereas an actual query plan includes runtime execution details.
An estimated query plan is a prediction based on available statistics whereas an actual query plan includes runtime execution details.
What are DMVs in SQL Server? Dynamic Management Views (DMVs) are system views in SQL Server. They provide insights into…
Temporal Tables in SQL Server Temporal Tables (also known as system-versioned tables) are a feature in SQL Server. They allow…
This article explains Correlated subqueries which are a powerful SQL feature for handling row-specific comparisons and complex conditions.
Performance tuning of a complex SQL query involves understanding its execution flow, optimizing query structure, and improving database interactions. In…
This article explain key concepts and best practices related to NULL value in SQL which help in mastering the NULL…
This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access…
SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax…
Complete months between two given dates Below script will help in finding the complete months within the 2 given dates.…
Complete weeks within two given dates Sometimes we need to find out the complete weeks within two given dates. Below…