One trick I find extremely useful is to set up a query short cut with "Select Top 1000 * From".

Then when I'm investigating a complex query I can...