I'm comparing between two techniques to create partitioned tables in SQL 2005. Use partitioned views with a standard version of SQL 2005 (described here) Use the built in partition in the Enterprise edition of SQL 2005 (described here) Given that the enterprise edition is much more expensive, I would like to know what are the main be...
I'm looking at this as a baseline explanation of the SQL 2005 Enterprise partitioning. Is there a resource that goes deeper into fine points and considerations of this issue. Some more examples would be useful too. My main scenario is a time based partition system. With one partition that has the most accessed last X days. This partitio...
Microsoft in its MSDN entry about altering SQL 2005 partitions, listed a few possible approaches: Create a new partitioned table with the desired partition function, and then insert the data from the old table into the new table by using an INSERT INTO...SELECT FROM statement. Create a partitioned clustered index on a heap Drop and re...
I have a partitioned table in SQL Enterprise 2005. I need to query the PARTITION FUNCTION to find it's partition ranges. What SQL query will give me those values? ...
Most examples dealing with table partitions, create the table on the partition scheme. For example: create table SomeTable ( Id int not null , DueDate DateTime not null ) on MyPartitionScheme(DueDate) Where MyPartitionScheme is a predefined partition scheme. If I have a table that already exists, possibly with data with it. Can...
Hi all, I'm currently benchmarking partitioned tables with SQL Server 2005 to compare them to using two tables (a "live" table and an "archive" table) for a processing queue. The partitioning's being performed on a bit column 'archive', so that when the archive bit is set, the row automagically moves. Initial testing seems to show that...
Hi Guys, I'm trying to create partitions in one big table, but I'm getting this error: 1505 - Partition management on a not partitioned table is not possible There is any command to convert the table? Or do I have to create a new one and import all data? There is any problem when using Partitioning with Replication? Thanks in advanc...
I'm considering various ways to partition my data in SQL Server. One approach I'm looking at is to partition a particular huge table into 8 partitions, then within each of these partitions to partition on a different partition column. Is this even possible in SQL Server, or am I limited to definining one parition column+function+scheme...