Column_nameType

Column1bigint

Column2bigint

Column3varchar

Column4bigint

Column5varchar

Column6bigint

Column7varchar

Column8bigint

Column9varchar

Column10bigint

Column11varchar

Column12bigint

Column13varchar

Column14varchar

Column15bigint

Column16bigint

Column17bigint

Column18numeric

Column19datetime

I Have Partitioned on cloumn 19, below are the space used details for the 'Table1' and partition details

name rowsreserved data ...

Yes, i referred the article, but i haven't see difference, is any other setting there ?

i go through the link

it is really fun !!, After partitioned, i observed it is time taken in Partitioned tables compared "Un Partitioned" Table.

Can you please help on this,...

Thanks for updating,

But, I have duplicate values in date column,