SELECT  -- 10 seconds
    COUNT(D1)
FROM
    #T  
WHERE PATINDEX('[0-9][0-9][-][0-9][0-9][-][0-9][0-9][0-9][0-9]%',D1)=1 AND D1 <>''