Web Analytics Made Easy - Statcounter

Sql Server

Understanding Estimated and Actual Query Plans in SQL Server

by
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?

by
Dynamic Management Views in SQL Server & its use

What are DMVs in SQL Server? Dynamic Management Views (DMVs) are system views in SQL Server. They provide insights into the internal workings of the database engine. These views expose details about the server’s health, configuration, performance, and activity. They enable database administrators (DBAs) to monitor, troubleshoot, and optimize SQL Server. DMVs are broadly classified … Read more

What are temporal tables in SQL and how to use them for historical data tracking?

by
Temporal tables in SQL Server

Temporal Tables in SQL Server Temporal Tables (also known as system-versioned tables) are a feature in SQL Server. They allow automatic tracking of historical changes to data over time. They maintain a history of all changes made to a table. This makes it easy to query past versions of data. You can also analyze trends. … Read more

Correlated Subqueries in SQL Server

by
Correlated Subqueries in SQL Server

This article explains Correlated subqueries which are a powerful SQL feature for handling row-specific comparisons and complex conditions.

How to approach for performance tuning of a Complex SQL Query

by
blank

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 the approach which can be helpful for performance tuning of a complex SQL query. To understand the approach, we will going to use some examples. In these examples, we have … Read more

Mastering NULL value in SQL Server

by
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 value in SQL Server.

Securing data in SQL Server

by
blank

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

SQL Triggers – An Introduction

by
SQL Triggers

SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax of the After trigger Example of After Trigger for Insert Example of After Trigger for Delete Example of After Trigger for Update Instead of Triggers DDL Triggers DDL Trigger for Create Table DDL Trigger for … Read more

Script to find complete months between two given dates

by

Complete months between two given dates Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as exampleStartdate =2015-07-05 Enddate =2016-01-06 /**********************Script Start**************************/ IF (object_id(‘tempdb..#month’) is not null) DROP TABLE #month CREATE TABLE #month (id int identity(1,1),MonthStartDate DATETIME,MonthEndDate DATETIME) DECLARE @startdate AS DATETIME … Read more

Script to find the complete weeks within two given dates

by

Complete weeks within two given dates Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script, I have used below dates as exampleStartdate=2015-04-12 Enddate=2015-06-10 SET DATEFORMAT YMD if (object_id(‘tempdb..#weekdays’) is not null) drop table #weekdays Declare … Read more