I recently worked on an issue called “Last Page Insert Contention,” which I had heard of before but never tackled firsthand until a few weeks ago.
This is excellent article thanks for educating us in this.
Excellent Article. Learnt something new for me. Thanks much
Thanks for the information. Will this OPTIMIZE_FOR_SEQUENTIAL_KEY setting increase index fragmentation as a side effect?
I haven't seen notably increased fragmentation due to this option. Being on cloud or on faster storage now-a-days, index fragmentation doesn't really matter in terms of performance.
This is excellent article thanks for educating us in this.
Excellent Article. Learnt something new for me. Thanks much
Thanks for the information. Will this OPTIMIZE_FOR_SEQUENTIAL_KEY setting increase index fragmentation as a side effect?
I haven't seen notably increased fragmentation due to this option. Being on cloud or on faster storage now-a-days, index fragmentation doesn't really matter in terms of performance.