Bits of .NET

This looks innocent:

WHERE DATEDIFF(day, CreatedAt, GETDATE()) = 0

❌ Why it’s bad

• Forces full scan

• Index becomes useless

✅ Fix

WHERE CreatedAt >= CAST(GETDATE() AS date)