How does INSERT, UPDATE & DELETE work on a SQL Server table partition?
Technical explaination please how the SQL server engine handles table partition vs non table partition.
+4
A:
The SQL optimiser will use the query predicates to decide on how many table partitions will be affected. This makes the query run faster as unnecessary data is not read from disk. The query will then be run against the relevant data blocks in the affected partitions. To the user this is completely transparent.
ar
2010-03-02 14:12:28
What actually is modified on the primary table? (apart from indexes)How does the SQL engine know where to insert the row, update, delete etc? there must be something to tell it "hey there partition table is located here"! ,
K001
2010-03-02 14:38:46
A:
I found this article by Kimberly Tripp to be incredibly useful in figuring out the ins and outs of table partitioning. It's about 40 pages long, technically detailed, and a printout sits on my desk as a permanenet reference.
Philip Kelley
2010-03-02 14:56:49