I bought a cheap SDS from Argos, specifically for core drilling. It has done a Stirling job of making 110mm holes for air vents in a rubble stone wall.
Points to note from my experience:
1. Make absolutely sure the drill has a clutch if you don't want broken wrists.
2. Let the drill take the strain, don't force it, take your time.
3. The drill is heavy, if you can support it, do it.
4. Goggles and ear defenders are essential!
5. A work platform is very useful if you are at any height.
6. For a neat finish start the drilling from both sides of the wall (it only needs to be a start on one side).
Points to note from my experience:
1. Make absolutely sure the drill has a clutch if you don't want broken wrists.
2. Let the drill take the strain, don't force it, take your time.
3. The drill is heavy, if you can support it, do it.
4. Goggles and ear defenders are essential!
5. A work platform is very useful if you are at any height.
6. For a neat finish start the drilling from both sides of the wall (it only needs to be a start on one side).