I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Backup and Performance
Find Missing Identity – SQL in Sixty Seconds #195
Today, we will discuss a very interesting topic about how to find missing identities from our database table. I have previously blogged.
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.
Using Stored Procedure in SELECT – SQL in Sixty Seconds #193
Today we are going to learn about how Using Stored Procedure in SELECT. However, the easiest method to run the stored procedure.
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.
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.
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.