Today, we will see a very interesting script to list database file latency. I use this script quite often in my Performance Health Check.
Indexing for Delete – SQL in Sixty Seconds #197
Today, we will see another interesting topic where the index affects the delete statement. Let us start watching the video Indexing for Delete.
Remove Key Lookup – SQL in Sixty Seconds #194
Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.
5 Questions Answered – Comprehensive Database Performance Health Check
Today’s blog post will try the 5 most questions asked for this popular service in the video format. Let us read the 5 Questions Answered.
Performance Troubles – Function on Date Variable – SQL in Sixty Seconds #192
However, I have a really good reason to use that. Today we are going to discuss Performance Troubles – Function on Date Variable.
Performance: Between and Other Operators – SQL in Sixty Seconds #191
If we use BETWEEN what will be the impact of performance. Let us watch Performance: Between and Other Operators.
Most Used Database Files – SQL in Sixty Seconds #190
If the client has multiple databases, this script helps to find out which database files is the most used. Let us learn today.