Create filtered statistics

Create Statistics <StatisticsName> 

On <TableName>(<columns list>) 

Where <condition>

Example:

CREATE STATISTICS ContactPromotion1

    ON Person.Person (BusinessEntityID, LastName, EmailPromotion)

WHERE EmailPromotion = 2

http://msdn.microsoft.com/en-us/library/ms188038.aspx