Dynamic DBCC DBREINDEX

This script uses sysobjects and sysindexes to ID all tables in a database that are indexed, and/or clustered.  It then runs through per table all of the indexes and runs DBREINDEX with their fillfactor.  This eliminates having to maintain a list of all indexes and having code fail when it tries to modify indexes that […]

2002-12-19

1,714 reads

Blogs

Social: Respecting Names

By

This is a non-technical post, and my opinion. If you don’t want to read...

Proud to present at this year’s VMworld 2020 conference

By

I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...

Daily Coping 7 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to be an MVP

By Kathi Kellenberger

Comments posted to this topic are about the item How to be an MVP

rename sa

By ramyours2003

i want to  rename the sa login with different name , is the jobs...

Does anyone have experience of using securetrading.net as a data src within ADF?

By wood.kieran

Hi, Does anyone have experience of using securetrading.net as a data source within Azure...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

BDC Storage

See possible answers