Sand

Does anyone know how I can create good sand with particles? I want to use particles becuase I’m creating a battle scene and I want the sand to pick up on wheels of vehicles and get blown up when hit, etc.
Does anyone know how to do that?

As far as I know, not even pro’s can do this with any realism. They just parent a sand cloud to whatever’s moving and have it turn on and off with it’s motion. To have actual interactive sand particles would kill Big Blue almost.