Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Redgate source control does not seem to recognize column Index's fill factor..

Redgate source control does not seem to recognize column Index's fill factor..

26 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
POST2010 shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Chris Smith responded  · 

SQL Source Control 3.0 is now available and includes a fix for this issue. Fill Factor should now be recognised by default.

For more information about v3, please visit:
http://www.red-gate.com/products/sql-development/sql-source-control/

Further Update: SQL Source Control v3.0.5.7 includes a mechanism to allow comparison options to be configured. To get this version, please run Check For Updates from the Help menu in SQL Source Control.

Comparison options can now be set via a configuration file in your database repository’s Working Base folder. The following article describes how to configure this option: http://www.red-gate.com/SupportCenter/GeneralContent/knowledgebase/SQL_Source_Control/KB201202000521

Show previous admin responses (2)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Justin Kong commented  ·   ·  Report

    Fill factor, padding, compression settings, SortInTempDB, DROP_EXISTING, ONLINE = OFF etc. are very important settings for us.

  • POST2010 commented  ·   ·  Report

    /*** 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