Identify T-SQL performance issues: missing indexes, implicit conversions, scalar UDFs, and NOLOCK misuse. Use when tuning slow queries or reviewing execution plans.
varchar column compared to int), causing index scans.READ COMMITTED SNAPSHOT when applicable.