This blog post aims to shed light on the performance impact between questions that use functions within the WHERE clause.
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 – Stripping HTML Tags from Text
In this blog post, we’ll explore a method for stripping these HTML tags from your text data using SQL Server. Let us explore the post.
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.
SQL SERVER – Techniques for Retrieving Random Rows
This post will explore various techniques to retrieve random rows in SQL Server and analyze their performance and randomness characteristics in depth.
The Pigeonhole Principle: Bridging Mathematics and SQL
The other day I was reading Wikipedia, and I ended up on the Pigeonhole Principle. I find it very intriguing about this and I decide to blog
SQL SERVER – Banker’s Rounding
Also known as unbiased rounding or round half to even, banker’s rounding follows a set of rules that ensures numbers are rounded.