I always thought it was a contraction of "that is the sh1t, isn't it?" (meaning "good") as used by rappers and other assorted illiterate morons.