mssql management studio
-
K
How can we use MSSQL Activity Monitor for the most expensive query?
If a slow query is running on server then it will consume more resources like memory, disk, processor etc. You can find these kinds of queries and manage them easily with SQL Activity Monitor. Login into your RDP. Open your MSSQL Management Studio and click on your particular user. After that...- kumkumsharma
- Thread
- Replies: 0
- Forum: MS SQL
-
K
Steps to change user access mode in MSSQL
With all the database features, there is restrict database access feature is also provided by MSSQL. Normally, there are 3 access modes are available Single User, Multiple User and Restricted User. You can easily change the User access mode in MSSQL Management Studio with below steps: Login to...- kumkumsharma
- Thread
- Replies: 0
- Forum: Windows