I recently talked about Ins and Outs of Online Index Operations with my clients during the Comprehensive Database Performance Health Check.
SQL SERVER Performance: Functions in WHERE Clause
This blog post aims to shed light on the performance impact between questions that use functions within the WHERE clause.
The Intricacies of T-SQL String Comparison: LIKE VS ‘=’
Let us learn The Intricacies of T-SQL String Comparison. In SQL, the way you compare strings can greatly impact the results of your queries.
SQL SERVER – Understanding Incremental Statistics
Statistics are updated automatically or manually rebuilt using full scans, can resource-intensive for large tables. Incremental Statistics.
SQL SERVER – Performance: OR vs IN – A Summary and Further Reading
The varied responses led me to write a detailed blog post to clarify the correct answer. If you missed it, you can read it here. Let us see A Summary and Further Reading.
SQL SERVER – The Comprehensive Guide to STATISTICS_NORECOMPUTE
One such feature that plays a pivotal role in managing your SQL Server databases’ performance is the STATISTICS_NORECOMPUTE option.