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
top of page
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.
231 views0 comments
rajendra gupta
Jan 5, 20221 min read
Drop Database in SQL Server
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.
339 views0 comments
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
148 views1 comment
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.
311 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
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"
220 views0 comments
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
rajendra gupta
Dec 31, 20211 min read
Who, When, and Why restarted my SQL Server?
Who, When, and Why restarted my SQL Server?
507 views0 comments
rajendra gupta
Dec 30, 20211 min read
T-SQL script to find out SQL Server Logs directory
T-SQL script to find out SQL Server Logs directory
161 views0 comments
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
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
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
48 views0 comments
rajendra gupta
Dec 26, 20212 min read
Generate Blocking tree in SQL Server and Azure SQL Database
Generate Blocking tree in SQL Server and Azure SQL Database
207 views0 comments
rajendra gupta
Dec 26, 20211 min read
Query To Kill All Active Connections in Azure SQL Database
Query To Kill All Active Connections in Azure SQL Database
247 views0 comments
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
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
222 views0 comments
rajendra gupta
Dec 17, 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
33 views0 comments
rajendra gupta
Dec 14, 20211 min read
List of SQL Server 2019 Cumulative Packs (CU)
List of SQL Server 2019 Cumulative Packs (CU)s
324 views0 comments
bottom of page