In this blog post, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance.
Majoring in the Minors in SQL Server Performance Tuning
We’ll explore how to avoid this common pitfall & Focus the areas that matter for performance improvements. Avoid majoring in the minors.
SQL SERVER – Aligned and Non-Aligned Indexes for Partitioning
In the context of partitioning, it’s essential to understand the concepts of aligned and non-aligned indexes. Let us learn about it today.
SQL SERVER – Comparing LIKE vs LEFT for Column Comparisons
Let us learn to compare LIKE vs LEFT for Column Comparisons. When writing SQL queries, developers have a myriad of options.
Function in the WHERE Clause – SQL in Sixty Seconds 201
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 – Ins and Outs of Online Index Operations
I recently talked about Ins and Outs of Online Index Operations with my clients during the Comprehensive Database Performance Health Check.
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.