SQL Server Execution Plan - Displays Estimated and Actual number of rows
This article focuses on getting the Displays Estimated and Actual number of Rows from the SQL Server Execution Plan. Read More
rajendra gupta
- Jan 19
- 1 min
How to disable current line highlight in SQL Server Management Studio(SSMS)?
How to disable current line highlight in SQL Server Management Studio(SSMS)?
35 views0 comments
rajendra gupta
- Jan 8
- 1 min
How to take SQL SERVER backup to Azure Blob Storage
How to take SQL SERVER backup to Azure Blob Storage. This is a guide for SQL Server DBA to store SQL SERVER backup in Azure.
161 views0 comments
rajendra gupta
- Jan 8
- 1 min
SQL Server script to change SQL Server Authentication Mode
A friend recently asked me how to change the authentication mode of SQL instances. This blog gives steps to change SQL Server authentication
16 views0 comments
rajendra gupta
- Jan 6
- 1 min
Steps to modify default SQL Server Management Studio - Select Top 1000 Rows and Edit Top 200 Rows
Do you want to modify the default Select Top 1000 Rows and Edit Top 200 Rows configuration in SQL Server Management Studio? Read more
25 views0 comments
rajendra gupta
- Jan 4
- 1 min
"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"
46 views0 comments
rajendra gupta
- Jan 4
- 2 min
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.
38 views0 comments
rajendra gupta
- Dec 28, 2021
- 1 min
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
60 views0 comments
rajendra gupta
- Dec 28, 2021
- 1 min
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...
110 views0 comments
rajendra gupta
- Dec 26, 2021
- 1 min
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...
30 views0 comments
rajendra gupta
- Dec 26, 2021
- 1 min
How to display Line numbers in SQL Server Management Studio(SSMS)
How to display Line numbers in SQL Server Management Studio(SSMS)
28 views0 comments