It helps that Stargate could get away with stuff that that would have to be done by VFX now. They had underpaid extras suffering heatstroke when these days some of the budget would've been used for digital crowds.
The other effects were somewhat standard rotoscope energy blasts and compositing the water effects.