It's pretty pathetic of those who always turn to Eccl.9:5 to prove their point, while ignoring all the other available scriptures which demonstrate conscious awareness of the spirit after death. Let's look at that scripture:
"For the living know that they will die, but the dead know nothing. They have no further reward, because the memory of them is forgotten. Their love, their hate, and their envy have already vanished, and they will never again have a portion in all that is done under the sun.
Since humans are made up of body, soul and spirit (Hebs.4:12), everywhere in scripture where the person who is dead and referred to as "sleeping" it is referring only to the body, not spirit. That is the only correct exegetical conclusion that one can come to seeing that we have other scriptures which demonstrate the spirit of both the righteous and wicked being conscious and aware after the death of the body. Therefore, when Eccl.9:5 says, "the dead known nothing" it is in reference to the body, which is said to be sleeping, while the spirit is elsewhere conscious and aware. Again I would remind you of the rich man who died and whose spirit was found in Hades in torment in flame. Furthermore, the rest of the scripture says "they have no further reward, because the memory of them is forgotten" which is because they are no longer alive on the earth and has nothing to do regarding the departure of the spirit. Your exegesis is incomplete and that because you only look at one example and then ignore the rest.
Stop thinking of "death" and "destruction" as being non-existent, because I guarantee you that is not the case.