because i need to be like this in date not just number.

It's business requirement, it was required from company to create like this.

Yes there is attached a file group on each partition. That's my problem.

Thank's for your response.

I changed the logic with count() function.

DECLARE @count int

SELECT @count = COUNT(*)

FROM events e

WHERE e.eventtime>DATEADD(dd ,-1 ,GETDATE())

...