Let us learn to compare LIKE vs LEFT for Column Comparisons. When writing SQL queries, developers have a myriad of options.
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 – Performance: Optimizing High Volume OR Conditions through TempTable
We explore an alternative approach when dealing with high volumes of ‘OR’ conditions in our SQL queries: the use of a TempTable.
SQL SERVER – Manage Database Size with DBCC SHRINKDATABASE and WAIT_AT_LOW_PRIORITY
In this blog post, we will explore the DBCC SHRINKDATABASE command and its options, focusing on the WAIT_AT_LOW_PRIORITY feature.
SQL SERVER – A Comparison of CHARINDEX vs LIKE
In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
SQL SERVER – Understanding Incremental Statistics
Statistics are updated automatically or manually rebuilt using full scans, can resource-intensive for large tables. Incremental Statistics.