I love the new information about queries displayed in ColdFusion 8's cfdump tag (you can see the SQL, the parameters, execution time, and cache status), but if you don't want all the extra information, just use the metainfo attribute:

<cfdump var="#myqueryissocool#" metainfo="false">

While not new to ColdFusion 8, don't forget you can also do "show" and "hide" to tell ColdFusion what columns to display. (This also works for structures.)