SQL Server
Copied!
Home
Options
2,788
David-Engel on 08-09-2019 02:12 PM
1,335
David-Engel on 08-05-2019 04:23 PM
1,755
David-Engel on 08-01-2019 01:51 PM
1,396
David-Engel on 08-01-2019 01:48 PM
1,938
David-Engel on 07-08-2019 04:11 PM
1,449
David-Engel on 05-16-2019 02:59 PM
1,332
DavidEngel on 04-17-2019 11:51 AM
1,114
Pam Lahoud on 03-29-2019 02:27 PM
788
Pam Lahoud on 03-29-2019 02:25 PM
754
DavidEngel on 03-29-2019 02:17 PM
516
SQL-Server-Team on 03-23-2019 06:09 PM
319
SQL-Server-Team on 03-23-2019 06:08 PM
292
SQL-Server-Team on 03-23-2019 06:03 PM
260
SQL-Server-Team on 03-23-2019 06:02 PM
212
SQL-Server-Team on 03-23-2019 06:01 PM
182
SQL-Server-Team on 03-23-2019 05:58 PM
192
SQL-Server-Team on 03-23-2019 05:57 PM
563
SQL-Server-Team on 03-23-2019 05:57 PM
178
SQL-Server-Team on 03-23-2019 05:54 PM
183
SQL-Server-Team on 03-23-2019 05:52 PM
183
SQL-Server-Team on 03-23-2019 05:50 PM
618
SQL-Server-Team on 03-23-2019 05:49 PM
612
SQL-Server-Team on 03-23-2019 05:48 PM
153
SQL-Server-Team on 03-23-2019 05:46 PM
142
SQL-Server-Team on 03-23-2019 05:43 PM
169
SQL-Server-Team on 03-23-2019 05:40 PM
150
SQL-Server-Team on 03-23-2019 05:37 PM
142
SQL-Server-Team on 03-23-2019 05:34 PM
324
SQL-Server-Team on 03-23-2019 05:34 PM
541
Pedro Lopes on 03-23-2019 05:34 PM
Latest Comments
@jahummer B-trees are self-balancing due to the way they are built from the bottom up (i.e. leaf first, then push up a new level when needed), so they never need to be "re-balanced" per se. Even a sequential index may need to be reorganized, however, if there are a lot of in place updates that cause...
0 Likes
@Rmwin Thanks for the feedback! Let me address your comment about page splits first. When a new page is added to the end of any level of an index (could be leaf or intermediate level), we do not move any rows around, we simply add a new empty page. The only time pages are left 50% full is when a new...
0 Likes
@Rmwin - good suggestions. For a sequential index yes the lowest level pages should not be 50% fill that's usually inefficient, except possibly for some odd configurations. However I believe the B-tree will still have to be re-balanced occasionally even with an optimized insert that minimizes half f...
0 Likes
Oh cool my comment lost all my formatting. I also seem unable to edit it... So a little correction. Where I wrote “Not many people what this issue”. I meant to write “Not many people have this issue”. Now I’ll see if more carriage returns allow me to format my text.
0 Likes
Seems like an interesting way to solve the issue. I’m just really curious why you even went to the effort to implement it? Firstly there are many known solutions, which often work much better (As you already mentioned in this article). Secondly, given the existence of Hekaton, I would have expected ...
0 Likes