View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 07:26 PM
Simon Hayes
 
Posts: n/a
Default 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


Reply With Quote