For follow-up discussion and general commentary on the topic. Comments are sorted chronologically.
In I Thessalonians 4:16, the Bible States, that in the second coming of Christ, the dead in Christ shall rise up first and we, the living, will rise up to meet them. Does this mean that the saved will be "sleeping" in their graves until the time of the second coming of Christ? Do we not immediately go before The Lord for His judgement upon the death of our earthly bodies? To whom does the dead in Christ refer?
That gets into the difference of God's perspective, which is outside of time, and man's perspective. To those that die, the Resurrection seems to happen immediately (I Cor 15:51-53), and we are present with the Lord (II Cor 1:5-10) - yet this is simultaneous with all other believers (Heb 9:27-28). There seems to be no awareness of centuries spent in the dust, even if the living are still aware of the passage of time.
I notice just about all the references are from the NT, but the foundation of all biblical understanding is established in the Torah ("Instruction/Teaching", also known as the Five Books of Moses), Nevi'im ("Prophets") and Ketuvim ("Writings")—hence TaNaKh.
To look at this question/subject an understanding needs to be developed beginning with all the accounts as they develop through scripture and then the hard part, the cultural understanding of the people at the time of the recording of those accounts. There is not a short and easy answer to this topic and you will be forced to consider view points that may be uncomfortable and different from what you now hold.
If you are serious to venture into this just remember this YHVH's promises and care are just as sure to the sleeping (dead) as to the living, Daniel makes that quite clear.
QOHELETH (ECCLESIASTES) 9
VS 10 All that your hand finds to do, do it
with your might; for there is no work or
planning or knowledge or wisdom in the
grave where you are going.