Does source control recognize Fill Factor and index padding?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Does source control recognize Fill Factor and index padding?

Postby sat » Thu Apr 07, 2011 8:59 pm

Redgate source control does not seem to recognize Index's "Fill Factor and index padding" changes.

Is there any option for fill factor setting?

/*** SCRIPT to create table with index fill factor andpadding ******/

-- Columns
CREATE TABLE [dbo].[test]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[column1] [int] NULL,
[column2] [int] NULL,
[column3] [int] NULL,
[column4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)

GO

-- Constraints and Indexes
[i]ALTER TABLE [dbo].[test] ADD CONSTRAINT [PK_test] PRIMARY KEYCLUSTERED ([id]) WITH (FILLFACTOR=90,PAD_INDEX=ON)
GO
CREATE NONCLUSTERED INDEX [IX_test] ON [dbo].[test] ([column2]) WITH(FILLFACTOR=90, PAD_INDEX=ON)
GO
CREATE NONCLUSTERED INDEX [IX_test_1] ON [dbo].[test] ([column4]) WITH(FILLFACTOR=90)

GO


/************* SOURCE CONTROL OUTPUT ************/


-- Columns

CREATE TABLE [dbo].[test]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[column1] [int] NULL,
[column2] [int] NULL,
[column3] [int] NULL,
[column4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
-- Constraints and Indexes

ALTER TABLE [dbo].[test] ADD CONSTRAINT [PK_test] PRIMARY KEYCLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_test] ON [dbo].[test] ([column2]) ON[PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_test_1] ON [dbo].[test] ([column4]) ON[PRIMARY][/i]
GO
sat
 
Posts: 5
Joined: Thu Apr 07, 2011 8:56 pm

Fill Factor

Postby AndrewBA » Fri Jun 03, 2011 8:01 am

I have the same question. Can I source control the <relational_index_option> parts of my index specification?
AndrewBA
 
Posts: 12
Joined: Tue Oct 27, 2009 7:08 am
Location: West Perth

Any Updates?

Postby sat » Thu Sep 29, 2011 7:17 pm

Is there any update for this issue??? when patch will be rolled out?
sat
 
Posts: 5
Joined: Thu Apr 07, 2011 8:56 pm


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 1 guest