MS SQL Server - Re: SQL Filegroups

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: SQL Filegroups

TRACEY

2006-10-31, 12:15 am

I was reading this message..

We just did this moved some of our reporting temp tables to a new drive..
What does the below mean?

"Tom Moreau" wrote:

> Which, of course, would cause quite an outage as exclusive table locks are
> thrown up when you build/rebuild clustered indexes.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
>
> "ch" <ch@dontemailme.com> wrote in message
> news:43CC256C. 21464780@dontemailme
.com...
> or you can create new filegroups with the files in the right place, and
> then go change all the tables and indexes from the old filegroup(s) to
> the new filegroup(s).
>
>
> Tom Moreau wrote:
>
>
>

Sponsored Links