O'Reilly logo
  • Dustin Waybright thinks this is interesting:

SQL Server knows that with a cross join followed by a filter it can evaluate the filters first (which is especially efficient when there are indexes to support the filters), and then match the remaining rows.

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

Thus optimizing what could be a massive product of rows.