In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.
This post will explore various techniques to retrieve random rows in SQL Server and analyze their performance and randomness characteristics in depth.
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
I wanted to share another useful programming technique for learning math – using stored procedures to check for Pythagorean triples.