• Interests: Spending time with family

Technical Article

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

You rated this post out of 5. Change rating

2002-12-19

1,741 reads

Blogs

Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS

By

One of the nice things about the Microsoft Connector for Oracle is that it...

ChatGpt Experiments–Getting Documentation

By

I get asked questions by salespeople all the time. Usually this is because a...

A New Word: Jouska

By

jouska – a hypothetical conversation that you compulsively play out in your head –...

Read the latest Blogs

Forums

Azure SQL Revealed: A Guide to the Cloud for SQL Server

By Site Owners

Comments posted to this topic are about the item Azure SQL Revealed: A Guide...

Refresh Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Refresh Limits

How Many Days Can You Survive?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Many Days Can You...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Refresh Limits

See possible answers