How Does Partition Assignment Relate to Transactions?
A user is assigned to a partition for the duration of a transaction. Assignment of partitions resumes with the first insert in a new transaction. The user holds the lock, and therefore partition, until the transaction ends. For this reason, if you are inserting a great deal of data, you should batch it into separate jobs, each within its own transaction. See “How Do I Take Advantage of Table Partitioning with bcp in?”, for details.
Related Questions
- We need to file a merger notification, but the current Notifiable Transactions Regulations relate to the Competition Act before it was amended. What do we do?
- What are HIPAA transactions and code sets rules? How do they relate to Minnesotas law and rules?
- How Does Partition Assignment Relate to Transactions?
