Mr. Spacemonkey: tss, now you jinxed it
Actually, it depends on how giant and how close that asteroid is gonna be... If it races close to us, it could still cause alot of weather disturbance and tidal waves would not be out of the question too I believe.
Also, wouldn't it be cool to see a massive rock flying overhead, just zipping past?