DBblogger | Rajendra Gupta | Page 14 of 16

top of page

WhatsApp Image 2021-11-26 at 4.32_edited.png

WhatsApp Image 2021-12-01 at 1.18_edited.png

T-SQL script to Recycle SQL Server error logs manually

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

45 views0 comments

How to disable ‘Completion time:’ message in SQL Server Management Studio message window

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

369 views0 comments

How to clear Server Names From List in SQL Server Management Studio (SSMS)

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...

478 views0 comments

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

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...

407 views0 comments

Generate Blocking tree in SQL Server and Azure SQL Database

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

206 views0 comments

Query To Kill All Active Connections in Azure SQL Database

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

242 views0 comments

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

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

How to display Line numbers in SQL Server Management Studio(SSMS)

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)

247 views0 comments

SQL Script to check database connections and their status

Dec 26, 20211 min read

SQL Script to check database connections and their status

SQL Script to check database connections and their status

219 views0 comments

SQL Server 2017 Cumulative Updates (CU)s

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

210 views0 comments

14

bottom of page