SQLPartitionMgmt Work Item Rss Feed

Created Issue: compression on partitions seems to be ignored [5338]

binarymechanic — Mon, 26 Oct 2009 19:11:28 GMT

Scripting a partitioned temp/staging table does not include reference to source table's level of page level compression.

Created Issue: Partition functions with a '.' in its name are not handled properly (and maybe so do the partition schemes). [5337]

MiSchroe — Mon, 26 Oct 2009 17:00:49 GMT

You can create a partition function with CREATE PARTITION FUNCTION [Person.PF_Address](int) RANGE LEFT FOR VALUES (10000, 20000, 30000);

This function will not be handled properly due to the dot ('.') in the name. It should work if you quote the name of the partition function with '[' and ']'. Maybe the same error will rise with a partition scheme with a dot inside the name.

Workaround: Changing the name of the partition function (e.g. replace all '.' with '_').

Closed Issue: Release 1.0 known issues: index creation order; 10-min. timeout

Stuarto — Mon, 23 Feb 2009 20:25:48 GMT

The following are known issues for Release 1.0. I've been informed by the developer(s) that these issues will be remedied with the next release, slated for 2008 Q4. The next release will also provide support for SQL Server 2008.

* There is no order enforced when building indexes, whereas it would be advantageous to create clustered indexes before creating nonclustered indexes on a non-empty table.

* Issued statements are given 10 minutes to run before failing with a time-out error. For example, if an individual index requires more than 10 minutes to create, an error will occur at the 10-minute mark. The remedy is to explicitly set the ServerConnection.StatementTimeout property to an appropriate value higher than the default value; the default value for this property is 600 (seconds, or 10 minutes).

Thanks to the developer(s) for such a valuable utility.
Comments: Fixed with Release 2.0

Created Issue: Release 1.0 known issues: index creation order; 10-min. timeout

TJY — Thu, 09 Oct 2008 03:03:46 GMT