What ultimately happened to Senator Joseph McCarthy's investigation on communists in the US?

Senator Joseph McCarthy investigation of communists in the US government and in the entertainment business ultimately came to an end when the US Congress censured him. His investigative tactics were judged to be extreme and President Eisenhower agreed with the censure.