SQL Server
Copied!
Home
Options
217
SQL-Server-Team on 03-23-2019 05:53 PM
224
SQL-Server-Team on 03-23-2019 05:52 PM
584
SQL-Server-Team on 03-23-2019 05:51 PM
532
Kyle Weller on 03-23-2019 05:49 PM
174
SQL-Server-Team on 03-23-2019 05:43 PM
163
SQL-Server-Team on 03-23-2019 05:40 PM
253
SQL-Server-Team on 03-23-2019 05:39 PM
210
Kyle Weller on 03-23-2019 05:38 PM
178
SQL-Server-Team on 03-23-2019 05:38 PM
229
Kyle Weller on 03-23-2019 05:38 PM
156
SQL-Server-Team on 03-23-2019 05:36 PM
182
SQL-Server-Team on 03-23-2019 05:32 PM
228
SQL-Server-Team on 03-23-2019 05:21 PM
165
SQL-Server-Team on 03-23-2019 05:20 PM
158
SQL-Server-Team on 03-23-2019 05:12 PM
174
SQL-Server-Team on 03-23-2019 04:59 PM
166
SQL-Server-Team on 03-23-2019 04:57 PM
155
SQL-Server-Team on 03-23-2019 04:55 PM
177
SQL-Server-Team on 03-23-2019 04:54 PM
164
SQL-Server-Team on 03-23-2019 04:51 PM
148
SQL-Server-Team on 03-23-2019 04:49 PM
153
SQL-Server-Team on 03-23-2019 04:48 PM
144
SQL-Server-Team on 03-23-2019 04:48 PM
152
SQL-Server-Team on 03-23-2019 04:42 PM
185
SQL-Server-Team on 03-23-2019 04:40 PM
269
SQL-Server-Team on 03-23-2019 04:40 PM
170
SQL-Server-Team on 03-23-2019 04:39 PM
180
SQL-Server-Team on 03-23-2019 04:39 PM
150
SQL-Server-Team on 03-23-2019 04:38 PM
151
Shau Phang on 03-23-2019 04:37 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...
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