Few even asked me to build a video on this topic. Hence, I decided to make a Function in the WHERE Clause – SQL in Sixty Seconds 201.
SQL SERVER – Generating Secure Passwords
We’ll explore industry guidelines for complex passwords and implement them in an SQL Server stored procedure to generate secure passwords.
SQL SERVER Performance: Functions in WHERE Clause
Functions in WHERE clause can hurt performance. I compare a query using YEAR() with one using direct column references on AdventureWorks, plus indexes.
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.
Repeatable Test Data With a Fixed Random Seed
Generate repeatable test data with a fixed RAND seed or row-number hashes, then verify identical names and amounts across runs.
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.