Let us learn how to Display Row Numbers in Query Editor for Efficient Query Editing. Comprehensive Database Performance Health Check
SQL SERVER – Reasons – Not Able to Shrink the Transaction Log
Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
SQL SERVER – Find Owner of Database – Change Owner of Database
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.