When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id]
Read More...
SQL Server 2005 table partitioning provides many improvements in terms of manageability and availability. This is an enhancement on taking the performance advantage on the aspects of manageability by allowing improvements to metadata only switch-in and
Read More...