Diadem Technologies Support Knowledgebase
MS SQL Server
Index Fragmentation Report in MSSQL Server
In order to get meaningful information about the fragmentation percentage of all indexes under the specified database from the sys.dm_db_index_physical_stats DMF, you need to join it with the sys.indexes DMV, as in the T-SQL script below: Step 1: Open MSSMS and click on New Query. Step...
rating 04 Mar, 2023 Comments: 0
rating 23 Nov, 2019 Comments: 0
Delete MSSQL Server DB from SQL Management Studio
How to Delete a SQL Server DB from management studio Before we begin we must know about Limitations and Restrictions while deleting a database from SQl server DB. System databases cannot be deleted. Prerequisites Delete any DB snapshots that exist on the database. If the database...
rating 19 Aug, 2019 Comments: 0
Restoring MSSQL database with Management Studio
Restoring MS SQL database with management Studio To restore a database we can follow two below mentioned procedure to restore the database. Restore SQL database using T-SQL Restore SQL database using SQL Server Management Studio Restore SQL DB using T-SQL To Restore SQL DB manually...
rating 19 Aug, 2019 Comments: 0
How to Create MS SQL Database Through SQL Server Management Studio
This article will assist you to create MS SQL database through SQL Server Management Studio. 1. Open Run box by pressing Windows key + R. 2. In Run box type SSMS and hit enter. This will open connect to server window.
rating 20 Jul, 2018 Comments: 0
How to connect to MSSQL Server from local SQL Server Management Studio
This article will guide you on how to connect to MS SQL Server from your local SQL Server Management Studio. You can obtain login details from VPS setup mail or by sanding a request to our support mail-id i.e. [email protected] from your registered mail-id. 1. Go to Start -> All Programs...
rating 20 Jul, 2018 Comments: 0
How To Restore a Microsoft SQL Database Backup Using SQL Server Management Studio
Steps to Restore a Microsoft SQL Database Backup Using SQL Server Management Studio. Open SQL Server Management Studio and Connect to the SQL Server you want to restore the database to. Once you Connected to the SQL server, right click on the Databases folder and select ‘Restore...
rating 19 Jul, 2018 Comments: 0
How to take MSSQL database offline or bring it online
Sometimes, you come across to a situations when you are required to physically move the database files. Online databases will not allow you such moving operations on “online” status therefore, you will require to take your database offline to accomplish it. You can do it from SQL Server Management...
rating 19 Jul, 2018 Comments: 0
How to change password for MS SQL admin user
Following tutorial will guide you to reset the MS SQL server sa user password. We assume that you have working sa or windows user password. 1. Login to MSSQL server by using current sa password through MS SQL management studio. 2. In left pane of Object Explorer, Click on Security ->...
rating 19 Jul, 2018 Comments: 0
How to configure MSSQL server default language configuration option
Recently, we faced strange issue wherein one of our customers was capturing error messages coming from SQL server and writing them into database table. These error messages could not help much to customer as error messages were in Spanish language. As a part of our primary investigation, we...
rating 17 Jul, 2018 Comments: 0
How to Change MS SQL Database Recovery Model
This article describes how to to change recovery model of a MS SQL database through SQL Server Management Studio and Transact-SQL. A recovery model database property tells SQL Server how you want to log the transaction logs. Mainly there are three recovery models in MS SQL Server. Simple Full ...
rating 17 Jul, 2018 Comments: 0
How to use MSSQL Activity Monitor to find the most expensive query
There are certain ways to identify and troubleshoot long running queries.This prevents potential performance issues. SQL Activity Monitor is the easiest and rich UI tool available in SQL Server Management Studio.It provides information about processor time, waiting tasks, database I/O, and...
rating 17 Jul, 2018 Comments: 0
How to Increase the MS SQL Remote Query Timeout
MS SQL Server has an option called Remote Query Timeout to specify the time (in seconds), a remote operation can take before SQL Server times out. Note that, it only applies to an outgoing (not incoming) connection initiated by the Database Engine as a remote query. The default value for this...
rating 17 Jul, 2018 Comments: 0
Take Full backup of MS-SQL database using management studio
To take the full backup of MS-SQL database, please follow the below steps 1. Open SQL Server Management Studio and connect to the appropriate instance of Microsoft SQL Server Database Engine in Object Explorer. 2. Expand Databases node and then right click on the database for which you want to...
rating 16 Nov, 2015 Comments: 0