Learn SQL | dbblogger

rajendra gupta

Jun 13, 20232 min read

Explain the difference between CHECKPOINT and LAZY Writer in SQL Server

1,246 views0 comments

Difference between ISNULL and COALESCE function SQL Server

rajendra gupta

Jun 13, 20231 min read

Difference between ISNULL and COALESCE function SQL Server

ISNULL and COALESCE functions can be used to handle null values in SQL Server. For a more detailed explanation, please refer to the video

421 views1 comment

Mastering SQL Server's Power: Unleashing the Potential of Common Table Expressions (CTEs)

rajendra gupta

May 26, 20233 min read

Mastering SQL Server's Power: Unleashing the Potential of Common Table Expressions (CTEs)

Discover the hidden gem of SQL Server: Common Table Expressions (CTEs). In this comprehensive guide, we dive deep into the world of CTEs.

231 views0 comments

How to Use a Cross Join in SQL Server: A Beginner's Guide

rajendra gupta

Apr 10, 20233 min read

How to Use a Cross Join in SQL Server: A Beginner's Guide

Learn how to use a cross-join in SQL Server.

698 views0 comments

WAIT_AT_LOW_PRIORITY Feature for DBCC SHRINKFILE in SQL Server 2022

rajendra gupta

Apr 6, 20231 min read

WAIT_AT_LOW_PRIORITY Feature for DBCC SHRINKFILE in SQL Server 2022

486 views0 comments

SQL Server - Where do my SQL Database files reside?

rajendra gupta

Dec 26, 20221 min read

SQL Server - Where do my SQL Database files reside?

271 views1 comment

Steps to add Add Identity Column to Table in SQL Server

rajendra gupta

Dec 26, 20221 min read

Steps to add Add Identity Column to Table in SQL Server

14,267 views0 comments

SQL Server 2022 - Greatest and Least functions

rajendra gupta

Dec 5, 20221 min read

SQL Server 2022 - Greatest and Least functions

This video tutorial guides you to learn SQL Server 2022 Greatest and Least functions with examples. #sqlserver #sqlserver2022

213 views0 comments

Learn SQL Server 2022 – DATE_BUCKET function

rajendra gupta

Dec 2, 20221 min read

Learn SQL Server 2022 – DATE_BUCKET function

This video article explains SQL Server 2022 DATE_BUCKET() function with examples.

299 views1 comment

SQL Server 2022 - IS [NOT] DISTINCT FROM Predicate

rajendra gupta

Nov 28, 20221 min read

SQL Server 2022 - IS [NOT] DISTINCT FROM Predicate

Do you know about the new SQL Server 2022 predicate - IS [NOT] DISTINCT FROM? Explore more in the video.

147 views0 comments

SQL Server: Explain the between SQL_Handle and Plan_Handle

rajendra gupta

Nov 21, 20222 min read

SQL Server: Explain the between SQL_Handle and Plan_Handle

What is the difference between SQL_Handle and Plan_Handle? SQL Server keeps track of different types of information using "handles." Read.

596 views0 comments

rajendra gupta

Nov 18, 20221 min read

Round up or Round down in SQL Server

SQL Server has a built-in function to round numbers up or down. Learn how to use this function to round up or round down numbers in SQL...

6,903 views0 comments

Different ways to check the last Restart time of SQL Server

rajendra gupta

Nov 16, 20221 min read

Different ways to check the last Restart time of SQL Server

Knowing when your SQL Server instance was last started can be helpful for various reasons. In this tip, we will explore a few methods you ca

7,100 views0 comments

T-SQL script to Measure Transactions Per Seconds in SQL Server

rajendra gupta

Nov 14, 20221 min read

T-SQL script to Measure Transactions Per Seconds in SQL Server

Learn how to measure transactions per second in SQL Server with this quick and easy guide. We'll show you step-by-step how to get started so

2,880 views2 comments

rajendra gupta

Nov 8, 20222 min read

Explore SQL EXCEPT statement

The SQL EXCEPT statement is used to compare two tables and find the differences between them. In this article, we'll show you how to use the

204 views3 comments

SQL Server UPDATE from a SELECT statement

rajendra gupta

Nov 7, 20222 min read

SQL Server UPDATE from a SELECT statement

Updating data in a SQL Server database can be done in many ways. One way is to use the UPDATE statement along with a SELECT statement. This

193 views0 comments

Jul 24, 20221 min read

SQL Server 2022 STRING_SPLIT Function

3,520 views0 comments

Jul 9, 20222 min read

Fundamental SQL: SQL Query examples for CREATE DATABASE

CREATE DATABASE: CREATE DATABASE is a fundamental SQL command that you need to know in order to work with databases.

263 views0 comments

Jul 5, 20222 min read

Learn about Case Statement in SQL Server

Case statements are used to provide instructions to be executed based on conditions. Case statements can be used in SELECT, INSERT, UPDATE,

82 views1 comment

Jul 5, 20221 min read

Convert Unix Timestamp in SQL Server (T-SQL)

Want to know how to convert a Unix timestamp to a SQL Server timestamp or vice-a-versa? This article shows you how to do it using T-SQL. Rea

10,170 views0 comments