New answers tagged partitioning
It sounds like your architecture has gone past partitioning and is sharded. If you have system software or an application framework in place which can handle sharding that is where this requirement should be implemented. In order to get the correct sort sequence you will have to have the results from all involved shards in the same place at the same time. ...
If you created the table with the above statement as user MDR_139, then that table belongs to the MDR_139 schema, not TESTSCHEMA. If you want to create tables in other schemas, add the schema specifier to the create statement, for example: create table TESTSCHEMA.sales_test (year number(4), product varchar2(10), amt ...
You cannot write your own partition function. What you need to do is create an additional column, assign a value resulting from the function you want to use, and partition on that column. Unfortunately, you cannot partition on a computed column, which would be the easiest solution.
TomTom has a great answer with which I completely agree. sp_BlitzErik rightly cites Kendra Little as a good source for acknowledging that partitioning is not a performance feature: Why Table Partitioning Doesn’t Speed Up Query Performance Partitioning is, in fact, a data management feature. As noted by TomTom, bulk DELETE operations that encompass the data ...
BCP works fine. First, you create the target table. Then export data with the select and filter you need. Import data with BCP will fit the correct partitions. I did this before. I was on SQL 2014, but it will be fine on 2012.
Top 50 recent answers are included