WITH
partitioned AS
(
SELECT
*
, DATEDIFF(Date, '1970-01-01') - ROW_NUMBER() OVER (ORDER BY Date ASC)
AS PartID
FROM
YourTable
)
SELECT
MIN(Date) AS StartDate
, COUNT(*) AS DayCount
FROM
partitioned
GROUP BY
PartID
HAVING
COUNT(*) > 1
ORDER BY
PartID
;