"That is fairly telling, that training people to understand SQL, and maybe write better queries and analysis themselves can make them much more efficient."

It is high time, IMHO, for every...

Look at this script:

http://www.sqlservercentral.com/scripts/contributions/26.asp

which will create transacations and free space for you.