Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: olahallengren/sql-server-maintenance-solution
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: main
Choose a base ref
...
head repository: marshallwp/sql-server-maintenance-solution
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: master
Choose a head ref
Checking mergeability… Don’t worry, you can still create the pull request.
  • 16 commits
  • 3 files changed
  • 7 contributors

Commits on Feb 18, 2021

  1. Changed subquery on index_resumable_operations to use 'state' instead… 

    … of 'state_desc'
    @muchinski
    muchinski committed Feb 18, 2021
    Configuration menu
    Copy the full SHA
    5e6b016 View commit details
    Browse the repository at this point in the history

Commits on Jan 17, 2022

  1. Update IndexOptimize.sql 

    Changed order of insert to move NORECOMPUTE before the RESAMPLE.
    @bwiggin10
    bwiggin10 authored Jan 17, 2022
    Configuration menu
    Copy the full SHA
    68fc638 View commit details
    Browse the repository at this point in the history

Commits on Mar 16, 2022

  1. Update IndexOptimize.sql - support columnstore 

    Add support for maintaining columnstore indexes
    @misha-sql
    misha-sql authored Mar 16, 2022
    Configuration menu
    Copy the full SHA
    b980985 View commit details
    Browse the repository at this point in the history

  2. Merge pull request #1 from misha-sql/IndexOptimize---columnstore-support 

    Update IndexOptimize.sql - support columnstore
    @misha-sql
    misha-sql authored Mar 16, 2022
    Configuration menu
    Copy the full SHA
    84515c2 View commit details
    Browse the repository at this point in the history

Commits on May 11, 2022

  1. Polybase Stats Rebuild Fix 

    Added functionality to correctly update statistics on external table.  Per MS, they cannot be ALTERED.  They must be dropped and recreated.    Added variable @ExternalTables.  Default is to REBUILD external table stats.  Any additional values will be ignored.
    @heaivilinn
    heaivilinn committed May 11, 2022
    Configuration menu
    Copy the full SHA
    be7a674 View commit details
    Browse the repository at this point in the history

Commits on Jun 29, 2022

  1. Update IndexOptimize.sql 

    fixes to original code to only use the current definition, rather than all columns.
    @heaivilinn
    heaivilinn committed Jun 29, 2022
    Configuration menu
    Copy the full SHA
    41c7f8d View commit details
    Browse the repository at this point in the history

Commits on Apr 14, 2023

  1. DatabaseBackup - Performance Fix 

    Fix performance issue with validation check that ensures the on disk names are unique.
#739
    @DavidWiseman
    DavidWiseman committed Apr 14, 2023
    Configuration menu
    Copy the full SHA
    95363da View commit details
    Browse the repository at this point in the history

Commits on Oct 27, 2023

  1. Update MaintenanceSolution.sql 

    Introduces a version of the Output File Cleanup job that is compatible with SQL Server 2017 CU18+ on all platforms.
    @marshallwp
    marshallwp authored Oct 27, 2023
    Configuration menu
    Copy the full SHA
    28614dc View commit details
    Browse the repository at this point in the history

  2. Merge pull request #1 from BinaryWizard904/Linux-Compatible-Output-Fi… 

    …le-Cleanup-Job

Introduce Linux-compatible Output File Cleanup Job
    @marshallwp
    marshallwp authored Oct 27, 2023
    Configuration menu
    Copy the full SHA
    a0b95ae View commit details
    Browse the repository at this point in the history

  3. Merge pull request #2 from muchinski/master 

    Changed subquery on index_resumable_operations to use 'state' instead of 'state_desc'.
    @marshallwp
    marshallwp authored Oct 27, 2023
    Configuration menu
    Copy the full SHA
    4611484 View commit details
    Browse the repository at this point in the history

  4. Merge pull request #3 from bwiggins10/master 

    IndexOptimize Fix NORECOMPUTE before the RESAMPLE issue
    @marshallwp
    marshallwp authored Oct 27, 2023
    Configuration menu
    Copy the full SHA
    f5d1d1b View commit details
    Browse the repository at this point in the history

  5. Merge branch 'master' of https://github.com/heaivilinn/sql-server-mai… 

    …ntenance-solution
    @marshallwp
    marshallwp committed Oct 27, 2023
    Configuration menu
    Copy the full SHA
    11309e4 View commit details
    Browse the repository at this point in the history

  6. Merge pull request #5 from misha-sql/master 

    Add support for columnstore indexes
    @marshallwp
    marshallwp authored Oct 27, 2023
    Configuration menu
    Copy the full SHA
    ad1088f View commit details
    Browse the repository at this point in the history

  7. Merged Changes to IndexOptimize into MaintenanceSolution.sql 

    Also converted tabs to spaces.
    @marshallwp
    marshallwp committed Oct 27, 2023
    Configuration menu
    Copy the full SHA
    c271a8f View commit details
    Browse the repository at this point in the history

Commits on Oct 31, 2023

  1. Merge pull request #6 from DavidWiseman/739_DatabaseBackup_Performanc… 

    …eFix

DatabaseBackup - Performance Fix
    @marshallwp
    marshallwp authored Oct 31, 2023
    Configuration menu
    Copy the full SHA
    781c23d View commit details
    Browse the repository at this point in the history

  2. Update MaintenanceSolution.sql 

    Brings in changes from merging pull requests.
    @marshallwp
    marshallwp authored Oct 31, 2023
    Configuration menu
    Copy the full SHA
    1484748 View commit details
    Browse the repository at this point in the history
Loading