Let me tell you something that took me a long time to say out loud. Human Can Make Mistakes Not AI. (Well, line inspired from famous GenAI tool).
The Strange Emotional Shift of Working Alongside a Machine That “Thinks”
Let us talk about The Strange Emotional Shift of Working Alongside a Machine That “Thinks”. The Night a Query Finished Before I Did
SQL SERVER – Execution Plans and Indexing Strategies – Quick Guide
Let us learn today in this quick guide Execution Plans and Indexing Strategies. Your comments are welcome
SQL SERVER – Catching Non-SARGable Queries in Action
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.