Technical Article

DB Reindex all Databases

This script reindexes all tables in all databases.  Execute the script with the desired fill factor and it will do the rest.  There is an option to exclude databases from the reindex. This makes it easy to reindex all newly created databases. Great for the Development environment when Developers are creating database all the time.

You rated this post out of 5. Change rating

2003-03-23

1,853 reads

Blogs

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 –...

PGSQL Phriday #009: On Rollback

By

The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty...

Read the latest Blogs

Forums

puzzeled with "exec sp_cursor 180150007,40,1"

By Johan Bijnens

I've noticed in one of our applications a cursor uses operation 40 and that...

Not wanting to use a Cursor, but...

By jwilkerson@valleymetro.org

Ok, need someone to talk me off the cursor ledge on this one. I...

Better Communication Through Less Messaging

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Better Communication Through Less Messaging

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers