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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by
on
Wed, Mar 12 2008
Filed under:
Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse