index performance

SQLServerCentral Article

How Bad are Bad Page Splits – The Rest of the Story

  • Article

In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the leaf pages of a clustered index with […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2020-07-02

4,554 reads

Blogs

How to Clear the SSMS Cache (SSMS 21 and Later)

By

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

The flight recorder: Replaying what an AI agent did on my SQL Server

By

“What exactly did it do on my server?” is the first question a DBA...

Announcements from the Microsoft Fabric Community Conference — Barcelona 2026

By

Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...

Read the latest Blogs

Forums

It's Never Just One Thing

By Grant Fritchey

Comments posted to this topic are about the item It's Never Just One Thing

Calculating Min-Max Normalization in PowerBI

By Dinesh Asanka

Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI

Checking the Error Log III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking the Error Log III

Visit the forum

Question of the Day

Checking the Error Log III

If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?

See possible answers