WD-40 will make tires REALLY sticky, but doesn't last very long. After 2 or 3 burnouts, it's back to normal...from my experience anyway.
You don't just spray it on and go run the car. You roll it on and let it soak into the tire overnight.

CHIP
'70 hemicuda, 575" Hemi, 727, Dana 60
'69 road runner, 440-6, 18 spline 4 speed, Dana 60
'71 Demon, 340, low gear 904, 8.75
'73 Chrysler New Yorker, 440, 727, 8.75
'90 Chevy 454SS Silverado, 476" BBC, TH400, 14 bolt
'06 GMC 2500HD LBZ Duramax