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 a client has many databases, this script finds the most used database files. Here is my SQL in Sixty Seconds video on it.
Reads and Writes per File: Rank Files by Bytes Moved
Reads and writes per file show which data or log file SQL Server uses the most. This post ranks the files of a demo database by bytes moved with sys.dm_io_virtual_file_stats and explains what the tally can and cannot tell you.
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.
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%.
Aggregate Pushdown: Letting the Columnstore Scan Do the Summing
Verify aggregate pushdown in columnstore scans, inspect locally aggregated rows, and compare numeric aggregates with expressions.