You'll probably get a lot of different responses. Some technical, and others based solely on experience. I've used lead shot, but have had a lot of interest in trying sand with lead shot, as the sand should fill in the spaces left by the shot.
If you decide to go with sand, make sure it doesn't have any moisture in it.
If you decide to go with sand, make sure it doesn't have any moisture in it.