Hi and thank you

Your advices changed my perspective about partitioning and relations to Performance.

OK

But the truth is that I had raised this issue, I must go to the end.(Only Partitioning Not performance)

Then I should First do the partitioning after that I must separated it with performance issue.

again thank you

And about my objects :

This is my partition scheme :

CREATE PARTITION SCHEME [PSchemaLog] AS PARTITION [PFunctionLog] TO ([FG_201408], [FG_201409], [FG_201410], [FG_201411], [FG_201412], [FG_201501], [FG_201502], [FG_201503], [FG_2015])

GO

This is my Partition Function :

CREATE PARTITION FUNCTION [PFunctionLog](date) AS RANGE LEFT FOR VALUES (N'2014-08-31T00:00:00.000', N'2014-09-30T00:00:00.000', N'2014-10-31T00:00:00.000', N'2014-11-30T00:00:00.000', N'2014-12-31T00:00:00.000', N'2015-01-31T00:00:00.000', N'2015-02-28T00:00:00.000', N'2015-03-31T00:00:00.000')

GO

more over

I have a Table : MyTable and a field : MyDateFiled