Medications such as morphine, Valium and Haldol have been found to have limited effectiveness in treating dementia-related agitation