Assume you have database called SalesCommission _DB in your SQL Server. You want to change the database files location from C: drive to S: drive due to disk capacity issue. You can use the ALTER DATABASE statement to move database files...
Read MoreAssume you have database called SalesCommission _DB in your SQL Server. You want to change the database files location from C: drive to S: drive due to disk capacity issue. You can use the ALTER DATABASE statement to move database files...
Read MoreAssume you have database called Sales_DB in your SQL Server. You planning to migrate this databases to another SQL Server and you want to place the database files (.mdf and .ldf) in different locations to those recorded in the backup...
Read More
Earlier today I was experiencing an issue with one of our databases called SALES_DB is in Restoring state. I tried to run below ALTER DATABASE commands on the database to set it in online state but it throws the following error.
[crayon-662c6a1cbb981621465987/]
The common language runtime (CLR) integration feature in SQL Server is off by default, Below SQL Script will help you to enabled CLR in order to use objects that are implemented using CLR integration. When CLR feature enabled in SQL...
Read MoreAs a DBA it’s handy to have a script to PING all the Link servers and get a report to examine the connectivity. Following T-SQL script will ping all the preconfigured linked servers and get the packets sent, received and...
Read MoreIf you are suffering from poorly performing linked server queries, you may wants to investigate the Linked Server CPU utilisation statistics. Following T-SQL script retrieves information such as SQL Process utilisation, System Idle time and Other Process utilization for a preconfigured MS SQL...
Read MoreIt’s handy to have a script to find failed SQL Server Agent Jobs. Most of the organizations execute resource intensive SQL process such as backup, heavy ETL process at night and it is essential to validate those import process daily...
Read MoreBelow script can be used to retrieve latest backup file datetime and physical location for all the Databases in preconfigured Linked...
Read MoreSometimes you may wants to retrieve a linked server configuration details. Following T-SQL statement retrieves information such as Hostname, SQL Instance name, Server Edition (32 bit or 64 bit), IP address, Port , ServicePack and cluster configuration for a preconfigured...
Read MoreSee below a simple script to find latest backup date time and physical location for all the Databases in a given SQL Server...
Read More