| Author |
Message |
sat
Joined: 07 Apr 2011 Posts: 5
|
Posted: Thu Apr 07, 2011 8:59 pm Post subject: Does source control recognize Fill Factor and index padding? |
|
|
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 |
|
 |
AndrewBA
Joined: 27 Oct 2009 Posts: 12 Location: West Perth
|
Posted: Fri Jun 03, 2011 8:01 am Post subject: Fill Factor |
|
|
| I have the same question. Can I source control the <relational_index_option> parts of my index specification? |
|
| Back to top |
|
 |
sat
Joined: 07 Apr 2011 Posts: 5
|
Posted: Thu Sep 29, 2011 7:17 pm Post subject: Any Updates? |
|
|
| Is there any update for this issue??? when patch will be rolled out? |
|
| Back to top |
|
 |
|
|
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