Timeline for Partition Tables Based on a non-Date Based Column
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 16, 2023 at 9:23 | history | edited | Michael Green | CC BY-SA 4.0 |
comment embedded
|
| Jan 6, 2023 at 15:43 | comment | added | David Browne - Microsoft | As commonly used an OFFLINE operation is one that performs substantial work while holding an Sch-M lock, and an ONLINE operation needs an Sch-M lock only while performing metadata changes, like an ONLINE index rebuild. So SPLIT of an empty partition would be considered in ONLINE operation, and SPLIT of a non-empty partition OFFLINE. | |
| Jan 4, 2023 at 3:53 | history | edited | Dan Guzman | CC BY-SA 4.0 |
Added T-SQL examples
|
| Jan 4, 2023 at 0:43 | vote | accept | Ross Bush | ||
| Jan 3, 2023 at 23:37 | history | answered | Dan Guzman | CC BY-SA 4.0 |