Q&A for Tridion developers and administrators
--select top(30000) Id,body, Tags from Posts where PostTypeId=1 order by Id --select top (30000) count(tags), tags from Posts where postTypeId=1 group by tags order by count(tags) desc --select top(150) (count) from Tags order by count desc --select Id,Tags,Viewcount from Posts order by viewcount desc; --select top(200) Posts.Body, Posts.tags from Posts Right Join Tags on Posts.tags = Tags.tagname where tags.tagname in Posts.tags (select top(10) Tagname from tags order by count) and Posts.PostTypeId=1 --select top(10) Posts.body, posts.tags, tags.tagname from posts,tags where tags.tagname in (select top(10) tags.Tagname from tags order by tags.count desc) select top(10) tags.tagname,tags.id ,tags.count from tags order by count desc --select top(10) * from posttags select top(5000) posts.body,posts.tags, tags.tagname from posts inner join posttags on posts.id= posttags.postid left join tags on tags.id = posttags.tagid where postTypeId=1 and tags.id =3 --in (select top(10) tags.id from tags order by tags.count desc )