OP - Very interesting article and thanks for posting.
While these types of articles are very informative, my take is to remain cautious and say that our reef aquariums *may* have similar microbial day/night shift characteristics. Since a good amount of microbial variability exists between geographically similar island reefs day and night, I have to wonder just how much variability exists between our different captive reef systems.
Ron Reeferman - The effects of sand bed vacuuming on the microbial community is an interesting topic. What we can say is that removal of some bacteria does occur (as well as some macro organisms), but the majority of essential nitrifing/denitrifying bacteria remains in sufficient quantity to rapidly repopulate. The periodic 'flushing of the system' is analogous to the seasonal storms that frequent tropical reefs and, to a lesser but more frequent extent, daily tidal current influences that redistribute and also transport detritus away from the reef itself. Having said that, larger systems that employ creatures that frequently turn over the sand bed (and actively suspend detritus which can then be trapped and removed from the system) may not require the sand bed vacuuming that helps smaller systems to remain viable long term.