Documentation is a bit thin

Mar 20, 2013 at 6:34 AM
Thanks for putting this together - it has saved a lot of time.

I did find the documentation a bit thin, in particular there isnt much info on each parameter or any explanantion of what the examples will do. Theres also no example of the IndexStaging command.

It would be great if that could be expanded.

Thanks
Mike
Coordinator
Mar 20, 2013 at 4:05 PM

Thanks for the feedback Mike. Will try to expand discussion as suggested. Glad it has been a timesaver…

- Stuart

From: MikeHoney [email removed]
Sent: Tuesday, March 19, 2013 11:35 PM
To: Stuart Ozer
Subject: Documentation is a bit thin [SQLPartitionMgmt:437284]

From: MikeHoney

Thanks for putting this together - it has saved a lot of time.

I did find the documentation a bit thin, in particular there isnt much info on each parameter or any explanantion of what the examples will do. Theres also no example of the IndexStaging command.

It would be great if that could be expanded.

Thanks
Mike

Mar 21, 2013 at 12:12 AM
Hi Stuart

Yes it has actually worked first time and cut the execution time for one tricky table in half.

This table is currently 60m rows, 13GB data, 10GB indexes (Page Compression), representing about 200 days of data. It receives a varying set of around 12 dates to refresh each day, and previously was deleting then inserting (via SSIS), then rebuilding indexes. A perfect scenario for this component!

A test query across a range of dates now runs 3 times faster - another win.

Thanks again
Mike