Hi again

Thank you All

I Did partitioning successfuly.

------------------------------------

But Unlike the proposed regulation I could have a better performance.

Database 1 : (Old db Without Partitioning - and 2 index : key cluster index on id - and non cluster on date )

select * from Table1 where RecDate between '2014-12-01' And '2014-12-05' And ClickUrl Like '%Tablet%'

Result :

Time = 1 Hour And 16 Mins

output = 584,224 Records

Database 2 : (New db With Partitioning - and 2 index : key Non cluster index on id - and cluster Index on Partition schema) - Partition on date - Every Month in a Partition

select * from Table1 where RecDate between '2014-12-01' And '2014-12-05' And ClickUrl Like '%Tablet%'

Result :

Time = 27 Mins !!!!

output = 584,224 Records

I Think this is Better Perfromance. (About One hour less time)