SQL 6/7

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

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 Script to find out Nth highest salary

rajendra gupta

Jan 7, 20221 min read

T-SQL Script to find out Nth highest salary

It is a standard SQL interview question where the interviewer asks to write a query that finds Nth highest salary from the employee table. H

53 views0 comments

Get a list of installed SQL Server Components with SQL Server Discovery Tool

rajendra gupta

Jan 5, 20221 min read

Get a list of installed SQL Server Components with SQL Server Discovery Tool

1,520 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

Dynamic SQL to move SQL Server TempDB Data and Log Files to different directories

rajendra gupta

Jan 5, 20222 min read

Dynamic SQL to move SQL Server TempDB Data and Log Files to different directories

89 views0 comments

move SQL Server TempDB database files to a different directory using Dynamic SQL

rajendra gupta

Jan 5, 20223 min read

move SQL Server TempDB database files to a different directory using Dynamic SQL

This article will explain the steps to change the SQL Server Tempdb database data and log file physical location.

241 views0 comments

rajendra gupta

Jan 5, 20221 min read

Drop Database in SQL Server

30 views0 comments

rajendra gupta

Jan 5, 20222 min read

Disable and Enable SQL Server Indexes

This article explains how to disable an Index in SQL Server.

341 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

158 views1 comment

Steps to change the default SQL Server backup directory

rajendra gupta

Jan 4, 20221 min read

Steps to change the default SQL Server backup directory

This article provides steps to change the default SQL Server backup directory.

314 views0 comments

rajendra gupta

Jan 4, 20222 min read

Learn SQL SELECT TOP statement

This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.

34 views0 comments

"Invalid Object Name" Error in SSMS for recently created objects

rajendra gupta

Jan 4, 20221 min read

"Invalid Object Name" Error in SSMS for recently created objects

Suppose you created a new table in SQL Server or Azure SQL Database, and the query editor shows you the error message "Invalid Object Name"

221 views0 comments

How to stop logging successful backup messages in SQL Server error logs

rajendra gupta

Jan 4, 20222 min read

How to stop logging successful backup messages in SQL Server error logs

This article guides you to stop logging successful backup messages in SQL Server Error Logs.

162 views0 comments

Who, When, and Why restarted my SQL Server?

rajendra gupta

Dec 31, 20211 min read

Who, When, and Why restarted my SQL Server?

508 views0 comments

T-SQL script to find out SQL Server Logs directory

rajendra gupta

Dec 30, 20211 min read

T-SQL script to find out SQL Server Logs directory

163 views0 comments

Increase or Decrease the number of error log files and their size in SQL Server

rajendra gupta

Dec 30, 20211 min read

Increase or Decrease the number of error log files and their size in SQL Server

Increase the number of error log files and their size in SQL Server

45 views0 comments

Configure the Minimum and Maximum memory for SQL Server Instance

rajendra gupta

Dec 30, 20211 min read

Configure the Minimum and Maximum memory for SQL Server Instance

Configure the Minimum and Maximum memory for SQL Server Database instance

36 views0 comments

T-SQL script to Recycle SQL Server error logs manually

rajendra gupta

Dec 30, 20211 min read

T-SQL script to Recycle SQL Server error logs manually

48 views0 comments

How to Specify SET ROWCOUNT value in SQL Server Management Studio (SSMS)

rajendra gupta

Dec 26, 20211 min read

How to Specify SET ROWCOUNT value in SQL Server Management Studio (SSMS)

I recently faced an issue where my query returns only five, whereas the table contains 542 records. The select statement does not have a...

415 views0 comments

SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication.'

rajendra gupta

Dec 26, 20212 min read

SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication.'

SQL Server Error 9002 – The transaction log for database <DBName> is full due to 'Replication'

178 views0 comments