If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer could non-SARGable queries.
SQL SERVER Performance Tuning: Catching Key Lookup in Action
In this blog post, we’ll explore what a Key Lookup is, how to spot it, and most importantly, how to eliminate it using a covering index.
Functions and Missing Indexes – SQL in Sixty Seconds 204
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.
The Columnstore Delta Store: Small Loads and Open Rowgroups
Inspect the columnstore delta store, distinguish rowgroup states, and choose load sizes or targeted compression after small loads.
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.