You could also skim coat the surface.
Both methods are time consuming and messy.
Depending on the room, consider using a Ralph Lauren textured paint - Suede or River Rock. These products are sold at Home Depots or call 1-800-379-POLO for other locations near you. You'd get a much nicer look than with a sand-based paint.