I don’t recall it ever having been used to bring people back after they’ve been killed; usually it’s only relevant in weird circumstances like when Scotty showed up in TNG