I have a fact table with many fields among which two important columns are Article Id and NewsDate. Article Id's are not in a specific order. They are random. So for partitioning can I use both Article Id and News Date for filtering.
select ArticleID,NewsDate from vwFactTableArticle
where ArticleID>5100000 and NewsDate>'2011-01-01'