MadeiraToolbox

MadeiraToolbox copied to clipboard

This Filter @ExcludeSysStats will be useful when we we need to Avoid Large Number of System Stats Generated

ChandraSaiKarthik

Add Where Clause to Find overlapped statistics + DROP statement.sql

1

Great script but it recommends removing statistics that are not completely overlapping. If the "overlapped" statistic is a filtered index then the script will recommend removing the auto generated statistic...

AndrewCLion

Add missing checks to the Condensed BP Check script

1

We have a "condensed check" script of best practices that we're usually using for the SQL Server Review: https://github.com/MadeiraData/MadeiraToolbox/blob/8f478c3166d8e3f0284bbea12a69f33afda7716d/Best%20Practices%20Checklists/Best%20Practices%20Condensed%20Check.sql However, it's incomplete, and missing several checks, most of which exist...

EitanBlumin

Best practices not suitable for Azure SQL

2

Hi, Is there any plan (or other script) that can check best practices for Azure SQL? I've tried using [this](https://github.com/MadeiraData/MadeiraToolbox/blob/078d5ecf3d86bce9f721d19f6e3cc4e81a6711e0/Best%20Practices%20Checklists/Best%20Practices%20Condensed%20Check.sql) but it failed as AzureSql doesn't have msdb access

Tovli