Index Rebuild

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 […]

4 (3)

You rated this post out of 5. Change rating

2020-07-02

4,460 reads

SQLServerCentral Article

How much will it cost or save to rebuild that index? (SQL Oolie)

  • Article

What's the true and permanent cost of lowering the Fill Factor of an index in SQL Server? It's a lot more than many people think. 9 year SQL Server MVP veteran, Jeff Moden, demonstrates how to calculate the extra space that will be used by lowering the Fill Factor and saved by increasing it.

4.35 (17)

You rated this post out of 5. Change rating

2021-05-28 (first published: )

10,108 reads

SQLServerCentral Article

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

  • Article

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]

5 (10)

You rated this post out of 5. Change rating

2019-08-08

6,276 reads

Blogs

Azure Cloud Chronicles with Microsoft MVPs YouTube Channel

By

In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...

T-SQL Tuesday #188: Growing the Community

By

This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...

Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse

By

PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...

Read the latest Blogs

Forums

Each database having its own disk?

By WebTechie

Good morning, Once again, I find myself Sr. DBA for a company.  As I...

the value of the effectiveusername xml for analysis property is not valid

By Bhagat

I'm experiencing odd behaviour when using Analysis Services as a data source in Excel...

the value of the effectiveusername xml for analysis property is not valid

By Bhagat

I'm experiencing odd behaviour when using Analysis Services as a data source in Excel...

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers