In part of the small change of copy editing, I regularly insert that when the writer has omitted it, or worse, when the editor has deleted it. There are people who will advise you that you don't need it, and I am here to tell you when you do.
When you don't need it: If you have two short clauses, one independent, one dependent, you can safely omit the relative pronoun. "She saw he was drunk."
And we do not typically use it after said. "She said he had been drinking since sundown the day before." One exception: Use that if there is a time element before the subordinate clause. "She said Friday that he had been drinking since Thursday afternoon."
When you do need it: Some verbs idiomatically take the relative pronoun and read awkwardly when it is omitted. They include advocate, assert, contend, declare, estimate, make clear, point out, propose, state, and testify.
When clauses are longer, using that is a signal that helps the readers sort out the syntax. "During the trial, video camera evidence showed proof that he staggered down the block."
Particularly if you have two subordinate clauses after the main clause, that helps the reader to identify each. "During the trial, video camera evidence showed proof that he staggered down the block and that he struggled to unlock the door of his car. "
And also this about that: There are people--I will not name them--who will tell you that it is insulting to human beings to refer to them with that, rather than who or whom. I do not name them because I have to expose their ignorance of the English language. The pronoun that has been used in English to identify people since King Alfred burned the cakes. Bryan Garner points out that the OED has citations going back 1,300 years.
There are, in fact, circumstances in which that works well in referring to people:
1. When the person's identity is not known, as in Irving Berlin's "The Girl That I Marry,"
2. When a group of people is indicated, as in the Authorized Version's "The people that walked in darkness have seen a great light."