Timeline for Why is it not possible to create indexes on temp tables in SNAPSHOT isolation?
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 21, 2020 at 15:53 | answer | added | NYCdotNet | timeline score: 3 | |
| May 16, 2018 at 4:35 | history | tweeted | twitter.com/StackDBAs/status/996610083948810245 | ||
| May 15, 2018 at 21:16 | vote | accept | Tom Pažourek | ||
| May 15, 2018 at 19:12 | comment | added | Tom Pažourek | @AaronBertrand It's how my application is structured at the moment. It didn't occur to me, but I suppose I don't really need to create it inside the transaction. Good point. It might be better to create it outside, after all, it's good to have the transactions as short as possible. | |
| May 15, 2018 at 19:08 | comment | added | Aaron Bertrand | Why do you have to create the #temp table inside the transaction? | |
| May 15, 2018 at 19:06 | answer | added | David Browne - Microsoft | timeline score: 11 | |
| May 15, 2018 at 18:58 | comment | added | Tom Pažourek | How can adding of index lead to inconsistency? Is there some way to add the indexes when I'm creating the temp table that wouldn't lead to these inconsistencies? | |
| May 15, 2018 at 18:56 | history | edited | Tom Pažourek | CC BY-SA 4.0 |
added 116 characters in body
|
| May 15, 2018 at 18:54 | history | asked | Tom Pažourek | CC BY-SA 4.0 |