Sleeping Pills - Sleeping pill side effects include daytime sleepiness, cognitive impairment, dizziness, and rebound insomnia. With misuse, they may also cause memory loss, sleepwalking, and hallucinations. For short-term use, Consumer Reports says sleeping pills can be helpful, but for no more than ten days in a row.