[Eugene.Ostroukhov]

про п.2: примерно так:

select cast(wf.xaml as xml).value('count(//*[@DisplayName="PromptExpression"])', N'int') as Questions
....
from ProcessSession ps
join Workflow wf on wf.WorkflowId = ps.ProcessId

(может кому пригодится)