Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 What does 'FILLFACTOR = 90 ON [PRIMARY] ' Mean?

Author  Topic 

ShaneChapman
Starting Member

1 Post

Posted - 2005-04-26 : 20:56:00
CREATE TABLE [dbo].[taContactTypes] (
[ctRecID] [RecordId] NOT NULL ,
[ContactType] [varchar] (32) COLLATE Latin1_General_CI_AS NOT NULL ,
[IsActive] [bit] NULL CONSTRAINT [DF__taContact__IsAct__3E1D39E1] DEFAULT (1),
[IsDeleted] [bit] NULL ,
[DisplayOrder] [int] NULL ,
[StatusFlags] [varchar] (32) COLLATE Latin1_General_CI_AS NULL ,
[CreateDate] [UserDate] NULL CONSTRAINT [DF__taContact__Creat__3F115E1A] DEFAULT (getdate()),
[CreateUser] [UserName] NULL CONSTRAINT [DF__taContact__Creat__40058253] DEFAULT (0),
[ModifDate] [UserDate] NULL ,
[ModifUser] [UserName] NULL ,
PRIMARY KEY CLUSTERED
(
[ctRecID]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-26 : 22:17:18
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c02ppcsq.mspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_5k8e.asp
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Those should give you more than enough information.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -