Home Forums SQL Server 2012 SQL Server 2012 - T-SQL fill factor with clustered PK on identity PLUS another column RE: fill factor with clustered PK on identity PLUS another column

  • March 29, 2017 at 4:27 pm

    #1935622

    A few critical tables would be a good start, particularly large child tables that are currently clustered on an identity column.

    Edit: Be sure to include any "missing index" (query 1) and "index stats" (query 2) results for all tables.  Note that there may not be any results from query 1 for some tables.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.