top of page
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 28, 20211 min read
How to disable ‘Completion time:’ message in SQL Server Management Studio message window
How to disable ‘Completion time:’ message in SQL Server Management Studio message window
372 views0 comments
rajendra gupta
Dec 28, 20211 min read
How to clear Server Names From List in SQL Server Management Studio (SSMS)
Do you have a long list of servers appearing in the drop-down of SSMS connection window. If yes, follow the steps in this article to...
488 views0 comments
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
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
209 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
254 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
How to display Line numbers in SQL Server Management Studio(SSMS)
How to display Line numbers in SQL Server Management Studio(SSMS)
259 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
224 views0 comments
rajendra gupta
Dec 24, 20211 min read
SQL Server 2017 Cumulative Updates (CU)s
Get a list of Cumulative Updates(CU) for SQL Server 2017 with downloadable links
213 views0 comments
bottom of page