top of page


Dynamic SQL to move SQL Server TempDB Data and Log Files to different directories
Dynamic SQL to move SQL Server TempDB Data and Log Files to different directories
rajendra gupta
Jan 5, 20222 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.
rajendra gupta
Jan 5, 20223 min read
Â
Â
Â


Drop Database in SQL Server
Drop Database in SQL Server
rajendra gupta
Jan 5, 20221 min read
Â
Â
Â


Disable and Enable SQL Server Indexes
This article explains how to disable an Index in SQL Server.
rajendra gupta
Jan 5, 20222 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
rajendra gupta
Jan 5, 20221 min read
Â
Â
Â


Steps to change the default SQL Server backup directory
This article provides steps to change the default SQL Server backup directory.
rajendra gupta
Jan 4, 20221 min read
Â
Â
Â


Learn SQL SELECT TOP statement
This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.
rajendra gupta
Jan 4, 20222 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"
rajendra gupta
Jan 4, 20221 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.
rajendra gupta
Jan 4, 20222 min read
Â
Â
Â


Who, When, and Why restarted my SQL Server?
Who, When, and Why restarted my SQL Server?
rajendra gupta
Dec 31, 20211 min read
Â
Â
Â


T-SQL script to find out SQL Server Logs directory
T-SQL script to find out SQL Server Logs directory
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
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
rajendra gupta
Dec 30, 20211 min read
Â
Â
Â


T-SQL script to Recycle SQL Server error logs manually
T-SQL script to Recycle SQL Server error logs manually
rajendra gupta
Dec 30, 20211 min read
Â
Â
Â


Query To Kill All Active Connections in Azure SQL Database
Query To Kill All Active Connections in Azure SQL Database
rajendra gupta
Dec 26, 20211 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'
rajendra gupta
Dec 26, 20212 min read
Â
Â
Â


How to display Line numbers in SQL Server Management Studio(SSMS)
How to display Line numbers in SQL Server Management Studio(SSMS)
rajendra gupta
Dec 26, 20211 min read
Â
Â
Â


SQL Script to check database connections and their status
SQL Script to check database connections and their status
rajendra gupta
Dec 26, 20211 min read
Â
Â
Â


Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
rajendra gupta
Dec 17, 20211 min read
Â
Â
Â


List of SQL Server 2019 Cumulative Packs (CU)
List of SQL Server 2019 Cumulative Packs (CU)s
rajendra gupta
Dec 14, 20211 min read
Â
Â
Â
bottom of page