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.
Optimize DATE in WHERE Clause – SQL in Sixty Seconds #189
During Comprehensive Database Performance Health Check, I often get questions about how to Optimize DATE in the WHERE Clause.
Performance Challenge – Write Efficient Query – Most Popular SQL in Sixty Video in 2021
Let me share one of the most popular videos from the SQL in Sixty Seconds. Video is about Performance Challenge – Write Efficient Query.
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.
Data Compression for Performance – SQL in Sixty Seconds #188
Earlier I wrote a blog post about how Data Compression for Performance can help improve the efficiency of SQL Server.
SQL Exclusive Video Released on YouTube
I have decided to collect all of my learning and build these SQL Exclusive Videos where I will be sharing my real-world experience in unedited videos.
CPU Running 100% – SQL in Sixty Seconds #185
I got lots of responses to this blog and people wanted me to create a video for this topic. Here, I have a video for CPU Running 100%.