SQL Server
Copied!
Home
Options
260
Sourabh Agarwal on 03-23-2019 05:25 PM
283
SQL-Server-Team on 03-23-2019 05:17 PM
667
Sourabh Agarwal on 03-23-2019 05:17 PM
115
Parikshit Savjani on 03-23-2019 05:15 PM
144
Parikshit Savjani on 03-23-2019 05:13 PM
109
Pedro Lopes on 03-23-2019 05:11 PM
144
Pedro Lopes on 03-23-2019 05:04 PM
56
Pedro Lopes on 03-23-2019 05:02 PM
196
Parikshit Savjani on 03-23-2019 04:49 PM
70
prashanthp1991 on 03-23-2019 04:49 PM
111
Pedro Lopes on 03-23-2019 04:46 PM
55
Pedro Lopes on 03-23-2019 04:44 PM
126
Pedro Lopes on 03-23-2019 04:42 PM
79
Pedro Lopes on 03-23-2019 04:41 PM
498
Parikshit Savjani on 03-23-2019 04:40 PM
62
Ajay Jagannathan on 03-23-2019 04:37 PM
175
Parikshit Savjani on 03-23-2019 04:36 PM
92
Sunil_Agarwal on 03-23-2019 04:35 PM
115
Parikshit Savjani on 03-23-2019 04:34 PM
66
Pedro Lopes on 03-23-2019 04:32 PM
47
Ajay Jagannathan on 03-23-2019 04:31 PM
110
Pedro Lopes on 03-23-2019 04:27 PM
96
Pedro Lopes on 03-23-2019 04:23 PM
66
Parikshit Savjani on 03-23-2019 04:23 PM
86
Bob Ward on 03-23-2019 04:21 PM
247
Parikshit Savjani on 03-23-2019 04:17 PM
68
Parikshit Savjani on 03-23-2019 04:16 PM
255
Sourabh Agarwal on 03-23-2019 04:13 PM
233
Sourabh Agarwal on 03-23-2019 04:02 PM
125
Parikshit Savjani on 03-23-2019 04:01 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...
0 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...
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