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.
What are DMVs in SQL Server and how to use them?
What are DMVs in SQL Server? Dynamic Management Views (DMVs) are system views in SQL Server. They provide insights into…
What are temporal tables in SQL and how to use them for historical data tracking?
Temporal Tables in SQL Server Temporal Tables (also known as system-versioned tables) are a feature in SQL Server. They allow…
Vertical and Horizontal partitioning in SQL Server
In the context of database management, partitioning refers to the technique of dividing large tables or indexes into smaller, more…
Difference between Actual & Estimated Execution Plan
The Actual Execution Plan and the Estimated Execution Plan in SQL Server provide insights into how a query will or…
Best Practices in SQL Coding
For any programming language, just writing the code is not well enough. It should be written using the best practices…
How to approach for performance tuning of a Complex SQL Query
Performance tuning of a complex SQL query involves understanding its execution flow, optimizing query structure, and improving database interactions. In…
Mastering NULL value in SQL Server
This article explain key concepts and best practices related to NULL value in SQL which help in mastering the NULL…
Securing data in SQL Server
This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access…