The Splinter Cell Conviction demo is finally out, it weights in at 1.19gb.
To get to the download you need to go to Games Marketplace, Game Demo's and then New Releases. Splinter Cell Conviction should be there.
From what I know, the demo features two non-successive story missions.