SQL backup files can quickly become very large and it might take a lot of space, which can cost quite a lot of money, so SQL Server enables you to compress them. You can set the default backup compression behaviour and...
Read MoreSQL backup files can quickly become very large and it might take a lot of space, which can cost quite a lot of money, so SQL Server enables you to compress them. You can set the default backup compression behaviour and...
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-6623c68830334286438621/]
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 More
Someone in my day job this week asked me how to deal with Msg 8134, Level 16, State 1, Line 3 Divide by zero error encountered error that they were receiving. It's second nature for me to add the below...
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 More