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.
2003-03-23
1,489 reads
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Hi, By default sql tries to restart on the same node in case of...
I page-compressed a table with one Clustered and 4 non-clustered indexes, 5 million rows....
Comments posted to this topic are about the item Iterating Over Calculated Tables using...
Ask SSC