Whilst looking at the Query Designer in Management Studio 2012 for a newsgroup post, I noticed it incorrectly translates bad joins, eg given the following query with a "bad" Cartesian join, the designer represents it as it should be, rather than correctly translating the text:
FROM dbo.FactInternetSales AS f
INNER JOIN dbo.DimProduct AS p ON f.ProductKey = p.ProductKey
INNER JOIN dbo.DimCustomer AS c ON f.CustomerKey = f.CustomerKey
WHERE p.ListPrice > 50
AND c.Gender = 'M'
I was going to suggest to the OP they could use the GUI to help visualise bad queries / check for Cartesian products, but it looks like they can't.