SEO

#1 (**permalink**) 02-28-2008, 07:25 PM

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

#2 (**permalink**) 02-28-2008, 07:26 PM

"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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

can you, by default, allocate uniform extents upon creation of index/table?