Logical

26 Jan 2006 9:08 PM

Joe K.

I would like to re-index two tables (t1 and t2) if the logical scan
fragmentation is greater 80% on these tables.

Please help me create a t-sql script to create this task.

Thank You,

27 Jan 2006 12:58 AM

Andrew J. Kelly

Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.

--
Andrew J. Kelly SQL MVP

Show quoteHide quote

"Joe K." <Joe K*@discussions.microsoft.com> wrote in message
news:D219E592-9000-49FB-AFE1-B109678802AC@microsoft.com...
>
> I would like to re-index two tables (t1 and t2) if the logical scan
> fragmentation is greater 80% on these tables.
>
> Please help me create a t-sql script to create this task.
>
> Thank You,