Red Gate forums :: View topic - Does source control recognize Fill Factor and index padding?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Does source control recognize Fill Factor and index padding?

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sat



Joined: 07 Apr 2011
Posts: 5

PostPosted: Thu Apr 07, 2011 8:59 pm    Post subject: Does source control recognize Fill Factor and index padding? Reply with quote

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
Back to top
View user's profile Send private message
AndrewBA



Joined: 27 Oct 2009
Posts: 12
Location: West Perth

PostPosted: Fri Jun 03, 2011 8:01 am    Post subject: Fill Factor Reply with quote

I have the same question. Can I source control the <relational_index_option> parts of my index specification?
Back to top
View user's profile Send private message
sat



Joined: 07 Apr 2011
Posts: 5

PostPosted: Thu Sep 29, 2011 7:17 pm    Post subject: Any Updates? Reply with quote

Is there any update for this issue??? when patch will be rolled out?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group