I have a little over six feet of 1" pipe as a spraybar in the back of my tank. Drilled with 3/16" bit every inch or two.
This is fed by a hammerhead that also feeds a 1" sea-swirl. The line to the sea-swirl is throttled slightly with a ball valve. I get decent flow across the bottom, it definitely can push sand and small bits of rock/coral to the front.
[Edit: I don't have sand, so that's why it doesn't blow around. Sand from rocks, dead halmedia, or whatever just moves to the front and spins in little cyclones until I siphon it out]