Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: fragmentation

Why index REBUILD does not reduce index fragmentatation with a page count > 1000?

By adminPosted on September 28, 2023

Question : This is kind of a followup to the existing question on this site “Why index REBUILD does not […]

What is the impact of temporarily setting ALLOW_PAGE_LOCKS ON

By adminPosted on September 28, 2023

Question : The MSDN ALTER INDEX page says “An index cannot be reorganized when ALLOW_PAGE_LOCKS is set to OFF.” I’m […]

PostgreSQL Initial Database Size

By adminPosted on September 2, 2023

Question : There are 2 parts to my question. Is there a way of specifying the initial size of a […]

avg_page_space_used_in_percent and fill factor

By adminPosted on August 30, 2023

Question : sys.dm_db_index_physical_stats contains column avg_page_space_used_in_percent. How does this fit in with the fill factor of an index? For example: […]

Online & Offline Index Rebuild

By adminPosted on August 7, 2023

Question : I had this weird case today. Inside a database I had about 50 (1000+ pages, most of them […]

Clustered composite key high fragmentation and fill factor

By adminPosted on July 20, 2023

Question : I’ve recently made a table to hold the language preferences of my users as follow: CREATE TABLE [dbo].[systemUserLangPreference]( […]

What is fragmenting my index on a table with stable traffic?

By adminPosted on July 17, 2023

Question : I am using Ola Hallengren’s solution for optimizing indexes. I run it on Sunday every week. The index […]

Index Fragmentation – log issues

By adminPosted on July 14, 2023

Question : I have a few questions that I want to understand in order to take informed decision. I am […]

Index fragmentation problem after disabling page-level locking for an Index

By adminPosted on July 11, 2023

Question : I have an Index which has page level locking disabled and now I have index fragmentation issues for […]

Index Maintenance – Reorganize After BIG SQL Server Shrink

By adminPosted on June 11, 2023

Question : I’m planning to execute the below index maintenance created by Ola Hallengren in a 1TB Database. EXECUTE [dbo].[IndexOptimize] […]

  • 1
  • 2
  • 3
  • …
  • 16

Recent Posts

  • Can sp_executesql be configured / used by default?
  • SQL Server Query Store – why does it not always use the forced plan? [duplicate]
  • Multiple query to columns indexed in MySql
  • cluster_database TRUE/FALSE what does it mean in Oracle RAC?
  • mysql – How to repair & backup archive table, also stop growing .ARN extension file?
  • How does the transactions interact if you set a different isolation level per connection?
  • Autovacuum in Postgresql database
  • MySQL Server 5.7.33 or upgrade
  • What are the performance implications of using uuid as primary key in Postgres 10.12? (need canonical answer) [duplicate]
  • How do I use subquery on the same table in MySQL?
  • Error on updating a field with binary values
  • Feasibility of a MSSQL Read Only Replicas as ephermal containers?
  • How to represent directed graph with multiple parents?
  • Promoting MySQL slave with unknown replication delay
  • Rules for Decomposition to 2 NF
  • Index with ops for `LIKE` and `=` queries
  • How many cores are used for serial plans in SQL Server?
  • MySQL read-write Master with many read-only Slaves over shared storage?
  • How to reference categories table in products table?
  • Automatically set value on child rows when deleting parent row?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding