The SQL Server PIVOT and UNPIVOT operators are powerful tools that provide an easy way to transform your data in SQL.
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 – 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 – Avoid Functions in the WHERE Clause for Performance
Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.
How to Write Efficient Query? – Interview Question of the Week #300
Question: How to Write Efficient Query?
Answer: There is no right or wrong answer to this question. Let us learn about it today.
SQL SERVER – Follow Up Question on Write Efficient Query
Earlier this week, I published a video Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140. The video got amazing feedback.