A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.
SQL SERVER – Display Dates in Different cultures FORMAT
Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.
Read-Ahead Reads in STATISTICS IO: What They Tell You
Interpret read-ahead reads in STATISTICS IO, compare isolated cold scans and seeks, and separate prefetch from storage-wait evidence.
9 SQL SERVER Performance Tuning Tips – SQL in Sixty Seconds #168
This episode of SQL in Sixty seconds is very special as it contains 9 SQL SERVER Performance Tuning Tips. The length of the video is also longer.
Excel – Sum vs SubTotal – SQL in Sixty Seconds #167
Just like SQL Server, I work with MySQL, PostgreSQL, MariaDB, MongoDB, and Excel. Today we are going to see in excel which is about Sum vs SubTotal.
SQL SERVER – 3 Queries to Detect Memory Issues
One of the most popular conversations during Comprehensive Database Performance Health Check is about CPU and memory issues.
Get CPU Details – SQL in Sixty Seconds #164
I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.