Need to test table partitioning & index creation

[VIJSQL01]

Hello,

I have been assigned to test partitioning and index creation for tables created in SQL Server environment. I do not know the approach. If possible i would like to automate this process.
Can anybody throw some light on this?

Thanks,
VIJSQL

 

[philhege]

What sort of testing? Feasibility? Performance?

You could certainly write a script or procedure to create a partition function and scheme, create a table and indices based on the scheme, and insert from an unpartitioned table or switch from a staging table (just guessing here as to what you actually have to do).

-----------
With business clients like mine, you'd be better off herding cats.

 

[VIJSQL01]

Thank you very much for the reply. Here i need to perform feasibility testing to verify that, whether the expected partitioning and indexing of the tables are done properly or not.