Partion Tables

[thulasi]

Hi ,

I want to implement partition tables in my production Database to improve performance of the query as well application.

can any one help me how to do partition for every quarterly....
example for one table how to do partition..

Thanks,
Thulasi

[rmiao]

Books online has details. How big the table is by the way?

[williamluotao]

use "job agent".

[rmiao]

Don't think job agent is related in this case.

[Lubor]

Be careful partitioning for "performance". Partitioning in SQL Server improves primarily manageability. You can backup/restore individual partitions, rebuild index on a single partition, run DBCC against single partition. Therefore rmiao's question on the table size is fully in place. Only large tables (millins of rows, tens of GB's) are good targets for table partitioning.

[thulasi]

Hi all,

I am implementing partition tables in my Database environment on Year range partition function.

i have a primary key on CustomerId.
But i want to implement Datecreated coulmn in this case how can apply partition scheme on datecreated.

Is that necessary that date created column should be a Primary key.

if any one help on this it would be highly appriciated.

Thanks,
Thulasi

[rmiao]

Not necessary pkey, better better to put clustered index on partitioned key column.