I would like to know about the Table partitions in SQL Server. How it work and where Can i get detail info about it...! Please share any info about Table Partitions