Hi! We are troubleshooting issues that are causing a high spike in lock requests on our database and I'm seeing queries with 'ands' where I believe there there should be inner joins. The ands I believe cause extra scans. We have developers putting ands before the where clause.
FROM dbo.Findings F
LEFT JOIN ONTIC.dbo.CUST_ORDER_LINE COL ON
F.SalesOrder = COL.CUST_ORDER_ID
AND F.SalesOrderLine = COL.LINE_NO
WHERE F.UserRecordNumber = '57695'
AND COL.LAST_SHIPPED_DATE IS NOT NULL AND COL.LAST_SHIPPED_DATE <> ''