Learn SQL | dbblogger 2/3

Mar 29, 20222 min read

Learn SQL NOT IN Operator

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

116 views0 comments

Difference between SQL COUNT(*), COUNT(1), COUNT(column_name) In SQL SERVER

rajendra gupta

Mar 28, 20222 min read

Difference between SQL COUNT(*), COUNT(1), COUNT(column_name) In SQL SERVER

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

51,936 views0 comments

An Overview of the SQL CHARINDEX function

rajendra gupta

Feb 27, 20221 min read

An Overview of the SQL CHARINDEX function

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

110 views0 comments

T-SQL Query to find SQL database age and number of tables in SQL Server

rajendra gupta

Jan 19, 20221 min read

T-SQL Query to find SQL database age and number of tables in SQL Server

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

335 views0 comments

rajendra gupta

Jan 18, 20222 min read

The SQL NULLIF function

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

47 views0 comments

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

rajendra gupta

Jan 13, 20221 min read

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

4,002 views2 comments

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

rajendra gupta

Jan 11, 20221 min read

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

34 views0 comments

SQL Server Management Studio Query Commands completed successfully without any Results

rajendra gupta

Jan 7, 20221 min read

SQL Server Management Studio Query Commands completed successfully without any Results

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?

128 views0 comments

What is SET NOEXEC ON in the T-SQL statement?

rajendra gupta

Jan 7, 20221 min read

What is SET NOEXEC ON in the T-SQL statement?

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.

72 views0 comments

T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server

rajendra gupta

Jan 5, 20221 min read

T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server

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

215 views0 comments

rajendra gupta

Jan 5, 20221 min read

Drop Database in SQL Server

30 views0 comments

T-SQL Script to generate Six Digit One Time Password (OTP)

rajendra gupta

Jan 5, 20221 min read

T-SQL Script to generate Six Digit One Time Password (OTP)

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

160 views1 comment

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

rajendra gupta

Dec 17, 20211 min read

Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database

33 views0 comments

SQL Server table Columns with NULL and NOT NULL values

rajendra gupta

Dec 13, 20212 min read

SQL Server table Columns with NULL and NOT NULL values

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

241 views0 comments

SQL Server - Find Business Days Between Dates

rajendra gupta

Dec 10, 20211 min read

SQL Server - Find Business Days Between Dates

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

197 views0 comments

rajendra gupta

Dec 10, 20211 min read

Find SQL Server Statistics Updated Date

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

418 views0 comments

When my SQL Server database was restored ?

rajendra gupta

Dec 10, 20211 min read

When my SQL Server database was restored ?

41 views0 comments

Get a list of supported Time Zones in SQL Server and Azure SQL Database

rajendra gupta

Dec 10, 20211 min read

Get a list of supported Time Zones in SQL Server and Azure SQL Database

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...

31 views0 comments

Identifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371

rajendra gupta

Dec 10, 20211 min read

Identifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371

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...

2,358 views0 comments

SQL Script to fix Orphan users in SQL Server database

rajendra gupta

Dec 9, 20212 min read

SQL Script to fix Orphan users in SQL Server database

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

2,630 views0 comments