SQL Server
Copied!
Home
Options
5,057
Pam Lahoud on 08-16-2019 10:44 AM
2,384
Tejas Shah on 08-02-2019 11:23 PM
6,816
EbruErsan on 07-30-2019 12:55 AM
7,100
Pedro Lopes on 04-03-2019 07:00 AM
3,287
Pedro Lopes on 04-01-2019 01:39 PM
785
Pam Lahoud on 03-23-2019 06:08 PM
800
SQL-Server-Team on 03-23-2019 06:08 PM
560
SQL-Server-Team on 03-23-2019 06:02 PM
1,039
Sourabh Agarwal on 03-23-2019 06:02 PM
2,164
Pedro Lopes on 03-23-2019 06:00 PM
348
Pam Lahoud on 03-23-2019 06:00 PM
324
Pam Lahoud on 03-23-2019 05:59 PM
408
Amit Banerjee on 03-23-2019 05:58 PM
387
Pedro Lopes on 03-23-2019 05:56 PM
244
SQL-Server-Team on 03-23-2019 05:55 PM
216
SQL-Server-Team on 03-23-2019 05:55 PM
241
SQL-Server-Team on 03-23-2019 05:55 PM
1,104
SQL-Server-Team on 03-23-2019 05:54 PM
346
Sourabh Agarwal on 03-23-2019 05:51 PM
237
Pam Lahoud on 03-23-2019 05:50 PM
400
Pedro Lopes on 03-23-2019 05:47 PM
757
Pam Lahoud on 03-23-2019 05:45 PM
328
Sourabh Agarwal on 03-23-2019 05:44 PM
282
Sunil_Agarwal on 03-23-2019 05:41 PM
627
dongcao on 03-23-2019 05:40 PM
284
Sourabh Agarwal on 03-23-2019 05:37 PM
512
Sourabh Agarwal on 03-23-2019 05:36 PM
281
Sourabh Agarwal on 03-23-2019 05:31 PM
234
Pedro Lopes on 03-23-2019 05:30 PM
248
Pedro Lopes on 03-23-2019 05:28 PM
Latest Comments
Let's hope those customers with many cores are running software from vendors that are advanced enough to implement something like this. I've had discussions with vendors to try to convince them that using cascading updates is a better way to cascade foreign key changes than "instead of" triggers. An...
1 Likes
@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...
1 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...
1 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