Table Partitioning in SQL Server
* It is a new feature introduced in SQL Server 2005. * While working with large tables, generally we face the following problems * Less performance. * Pressure increases on the hardware where the table is created. * Index size also increases. * We have to rebuild or reorganize the complete index always. * To overcome all these problems...