>It still lasts. Until all stored procedures are natively compiled - into what - CLR? - then both sprocs and queries continue to use the cached plans.
Oh I know, was just needling a bit.
They're compiled into the CLR at the time they're created, so plans are defined at create time as opposed to invocation time.
Again, it's somewhat of a niche feature, one where you definitely have to hit a sweet spot. But when you hit it, the performance gains are significant.