Timeline for Is there a stronger guarantee of minimal logging when running INSERT INTO [...] WITH (TABLOCK) on a heap than on a B-tree?
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Nov 16, 2023 at 11:38 | history | bounty ended | J. Mini | ||
| S Nov 16, 2023 at 11:38 | history | notice removed | J. Mini | ||
| Nov 16, 2023 at 11:38 | vote | accept | J. Mini | ||
| Nov 9, 2023 at 8:42 | answer | added | user3402754 | timeline score: 1 | |
| S Nov 9, 2023 at 7:58 | history | bounty started | J. Mini | ||
| S Nov 9, 2023 at 7:58 | history | notice added | J. Mini | Authoritative reference needed | |
| Nov 6, 2023 at 21:03 | comment | added | J. Mini | @Charlieface I suspect that is a full answer. | |
| Nov 6, 2023 at 17:31 | comment | added | Charlieface | From a different document "If the table has a clustered index and is empty, both data and index pages are minimally logged. In contrast, if a table has a B-tree based clustered index and is non-empty, data pages and index pages are both fully logged regardless of the recovery model." learn.microsoft.com/en-us/sql/relational-databases/… | |
| Nov 6, 2023 at 13:52 | history | asked | J. Mini | CC BY-SA 4.0 |