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.
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.
Get Current Time Zone – SQL in Sixty Seconds #187
Lots of people often ask me how to get the current time zone in SQL Server when I am working on Comprehensive Database Performance Health Check.
Detecting Memory Pressure – SQL in Sixty Seconds #186
Lots of people who watched the video also asked me to build a similar video. Let us see today a video where I explain how to detect memory pressure.Â