Skip to content

Instantly share code, notes, and snippets.

@jeffjohnson9046

jeffjohnson9046/index-fill-factor.sql

Created July 27, 2015 06:14
Show Gist options
  • Save jeffjohnson9046/77cea0a9d55c42d831af to your computer and use it in GitHub Desktop.
Save jeffjohnson9046/77cea0a9d55c42d831af to your computer and use it in GitHub Desktop.
Download ZIP
MSSQL: Inspect Indexes and their fill factor settings
Raw
index-fill-factor.sql
SELECT OBJECT_NAME(object_id) as table_name, name, type_desc, is_primary_key, fill_factor FROM sys.indexes;
USE [whatever database]
GO
ALTER INDEX PK_GeoRoot ON GeoRoot
REBUILD WITH (FILLFACTOR = 80);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment