Re: can you, by default, allocate uniform extents upon creation of index/table?
"Doron" <doron_almog@msn.com> wrote in message
news:995517bc.0401061420.4ce45d62@posting.google.c om...
> is there a setting that will ebnable uniform extent allocation upon
> creation of index/table by default ?
> if there isn't any default setting can you code it in?
>
> thanks,
> Doron
No - there's no direct way to control how MSSQL allocates tables/indexes to
extents (see "Pages and Extents" in BOL). If you have a specific problem,
perhaps you can give more details, and someone may be able to suggest a
solution.
Simon |