sql-server-maintenance-solution
sql-server-maintenance-solution copied to clipboard
olahallengren
SQL Server Maintenance Solution
Hi Ola, Avid user of your code, wouldn't go without it. Come across a problem recently where Geospatial Developers have requested to maintain Spatial Indexes independently from the rest of...
**Description of the issue** Existence of a user table (e.g. CommandLog) **with an index** in **Master** of Managed Instance causes IndexOptimize to fail **SQL Server version and edition** Azure SQL...
Similar to the MirrorDirectory parameter, I'd like to have a way to write backups alternatively to 2 (or more) locations. In my environment, I have 2 file servers dedicated to...
When a log backup is scheduled, only to run it if the log file is above a certain percentage (75% as an example).
Hello Allen, it would be useful if in the index optimize script the option "Incremental (OFF or ON)" could be a parameter, in order to user the @OnlyModifiedStatistics nvarchar(max) =...
Hello, I am trying to understand if the time taken to calculate the index fragmentation is also logged in the Command Log table as a part of IndexOptimize process. Any...
I used this solution for years and it saves me a lot of time. Thank you, ola and team. Recently, I found one issue: when a table was disabled via...
**Description of the issue** Our master user encounter an error while running the IndexOptimize.sql in SQL Server AWS RDS. **SQL Server version and edition** Execute ```SELECT @@VERSION``` Microsoft SQL Server...
**Description of the issue** DB_ID() might return the wrong database id in Azure **SQL Server version and edition** Execute ```SELECT @@VERSION``` Azure DB **Version of the script** Check the header...
In some SQL Server instances, we have an arrangement where there is one database per customer and the database name is based on user input. In these instances, where there...
