The SQL NOT IN operator is used to find entries in a table that are not in a list of values. Learn how to use this SQL operator

What is the difference between COUNT(*), COUNT(1), and COUNT(column_name) in SQL Server? Read all about it here.

The SQL CHARINDEX function is used to find the position of a character or substring within a string.

SQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.

NULLIF is a SQL function that is used to compare two columns. Use NULLIF to compare two columns and return NULL if they are equal to each ot

T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)

Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database

Do you want to compile the query without executing it? If yes, you can use SET NOEXEC ON at the beginning of the T-SQL statement.

I recently came across a strange issue where the query does not return any row in SQL Server Management Studio. How do we solve this issue?

This article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored procedure.

This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function

Drop Database in SQL Server

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...

This article helps you get the SQL Server agent job name from the hexadecimal Job ID format. Let’s say you have deadlock information that...

Recently, my client asked me to calculate the date difference, excluding only Sunday. How do you calculate days using the T-SQL script?...

This SQL Server Tutorial talks about finding out the last Statistics Update Date in SQL Server. We all know that Statistics are vital for...

Do you want to find out supported time zones in SQL Server and Azure SQL Database? If yes, get the query in this article. The...

When my SQL Server database was restored ?

This blog post explains Orphan user and provides a script to fix Orphan users in SQL Server database. The basic process to create a...