'super cool' or 'awesome'
or it can mean 'really tight' in the literal sense
Urvashi: Wow those pants are heckatight!
Bob: Thanks I bought them at WALMART!
by Urvashi August 31, 2008
Get the Heckatight mug.