Rob Pincus, back in Valhalla days had a great DVD segment on this, complete with sheetrock walls, hallways, adjoining rooms etc,...
One would be surprised even how much penetration occurs, even with a .38.
I wonder if it's here at the DRTV archives, or if Rob can post a link. It was very informative, from 38 to 45, to 12g...