SQL Server
Copied!
Home
Options
35
SQL-Server-Team on 03-23-2019 04:35 PM
29
SQL-Server-Team on 03-23-2019 04:33 PM
32
SQL-Server-Team on 03-23-2019 04:33 PM
33
SQL-Server-Team on 03-23-2019 04:32 PM
28
SQL-Server-Team on 03-23-2019 04:31 PM
41
SQL-Server-Team on 03-23-2019 04:31 PM
32
SQL-Server-Team on 03-23-2019 04:30 PM
25
SQL-Server-Team on 03-23-2019 04:30 PM
40
SQL-Server-Team on 03-23-2019 04:30 PM
37
SQL-Server-Team on 03-23-2019 04:25 PM
39
SQL-Server-Team on 03-23-2019 04:24 PM
40
SQL-Server-Team on 03-23-2019 04:21 PM
30
SQL-Server-Team on 03-23-2019 04:18 PM
27
SQL-Server-Team on 03-23-2019 04:18 PM
30
SQL-Server-Team on 03-23-2019 04:18 PM
52
SQL-Server-Team on 03-23-2019 04:15 PM
45
SQL-Server-Team on 03-23-2019 04:14 PM
31
Amit Banerjee on 03-23-2019 04:14 PM
34
SQL-Server-Team on 03-23-2019 04:13 PM
29
SQL-Server-Team on 03-23-2019 04:12 PM
27
SQL-Server-Team on 03-23-2019 04:12 PM
27
SQL-Server-Team on 03-23-2019 04:11 PM
240
SQL-Server-Team on 03-23-2019 04:11 PM
34
SQL-Server-Team on 03-23-2019 04:03 PM
31
SQL-Server-Team on 03-23-2019 04:02 PM
40
SQL-Server-Team on 03-23-2019 04:00 PM
60
SQL-Server-Team on 03-23-2019 04:00 PM
51
SQL-Server-Team on 03-23-2019 03:57 PM
36
SQL-Server-Team on 03-23-2019 03:57 PM
26
SQL-Server-Team on 03-23-2019 03:56 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