Fillfactor missing from SQL Script

Documents SQL Server 2000, 2005 and 2008 databases.


Moderators: David Atkinson, david connell, Charles Brown

Fillfactor missing from SQL Script

Postby pdrapeau » Fri Jan 11, 2008 5:18 pm

Hello,

I have noticed that the fillfactor values of indexes appear in the Indexes table but are not present in the SQL Script text.

IDX_UBI_USER_STATUS_ID 60 PS_UBI_USERS_USER_ID

Code: Select all
CREATE NONCLUSTERED INDEX [IDX_UBI_USER_STATUS_ID] ON [dbo].[UBI_USER] ([STATUS_ID], [USER_ID])


Is it normal?

Thanks
pdrapeau
 
Posts: 2
Joined: Wed Jan 09, 2008 3:43 pm

Postby Brian Donahue » Tue Apr 01, 2008 1:03 pm

Hi,

It appears that the schema options that SQL Doc uses include an option to ignore fillfactors. We should be able to change this easily in the next version of SQL Doc and get the change out soon.

Thanks for pointing this out.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Doc 1

Who is online

Users browsing this forum: No registered users and 1 guest