I have yet to determine the specifics of what the performance hit is, but basically other users simply start to suffer very poor query performance and/or timeouts (this is via the...

OK, so Eirikur's comment about the query taking locks is technically correct but misleading (at least to me) because the Read Uncomitted query might be taking out schema locks but...