Microsoft SQL Server
TRANSACT-SQL: JOIN…ON condition or WHERE condition – which is better?
A colleague suggested I write about this topic as she often wonders about it, but doesn’t really understand the implications and has never had a chance to test it. Basically, the question is whether it’s better to add a condition in a query in the WHERE clause at the end Read more…