Aggression is the norm. An anti-depressant lessens the bouts, but wears off quickly. My best friend in Texas said with her Alzheimer Father anti-depressants didn't help but anti-anxiety meds did & recommended I look into .25 mg aprazolam (stronger) or lorazet .5 mg (milder)
Also, have a look at this list of suggestions, and see if there is anything you can try to help reduce the problem: https://www.agingcare.com/articles/Incontinence-and-Sleep-Problems-108031.htm
I know first hand how extremely detrimental to the caregiving situation night disturbances can be. If I couldn't sleep for days on end I became a zombie caring for the demented. Not at all a safe or pleasant picture. My husband's neurologist was able to come up with a pharmaceutical solution to our problem.
While you are working toward this goal, (waiting for doc appointments, trying possibly more than one drug, etc.) I urge you to make in-home care arrangements so you can get some sleep.
Talk to the doctor. There are pharma ways to handle this problem.