Hi readers, this post was about a weird SQL Server behavior related to column scoping and correlated subqueries. I executed this query at my work (changed DB/table names): SELECT * FROM Students WHERE ...

🔍 SQL Performance Tip Today I optimized a slow-running query in SQL Server by: • Reviewing the execution plan • Identifying missing indexes • Refactoring a correlated subquery into a JOIN Result: ...