Bits of .NET

IF EXISTS (
  SELECT 1 FROM Orders WHERE CustomerId = 42
)
BEGIN
  PRINT 'Has orders'
END

Why it’s faster

• Stops at the first match

• Avoids full scans

• Reduces CPU usage