As there was no owner, it was not possible to open that database in the SSMS. We had to find Owner of the Database and change it later on.
SQL SERVER – Sample Script for Compressed and Uncompressed Backup
I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Well, of course.
SQL SERVER – Find Missing Identity Values
I recently received a question during Comprehensive Database Performance Health Check about how to Find Missing Identity Values.
SQL SERVER – Using Stored Procedure in SELECT Statement
A very popular question I often receive during my Performance Health Check is about how to use stored procedures in SELECT Statement.
SQL SERVER – Most Used Database Files – Script
If the client has multiple databases, this script also helps us to find out which database and particularly which database file is the most used.
MySQL – Recover Dropped Performance Schema Database
Earlier today I saw the question in an online forum where the user was looking for ways to recover Dropped Performance Schema Database in MySQL.
SQL SERVER – Script to Estimate Compression
I had implemented Data Compression at my client Performance Health Check. Let us discuss how we can estimate compression.