My secondary monitor goes all squirly occasionally when I wake the displays. It's a NEC Multisync 3090WQXi and a very nice display. I suspect the issue is the Apple DVI adapter. If you have similar issues, the most reliable and easy solution is to force the displays to sleep and wake.
There's a shortcut key combo for sleeping displays: ctrl-shift-eject.