Erik Darling

Add a job that only updates statistics

1

**Add a job that updates statistics without doing index maintenance** I publish a script that creates a job to do this here: https://github.com/erikdarlingdata/DarlingData/tree/main/OlaStatsOnly I think it would be good for...

Should new memory columns be divided by 8?

2

Looking at the new columns for `@get_memory_info`, they seem to account for memory grants a big strangely. There may be a good reason for this that I can't find reference...

Update sp_WhoIsActive.sql

1

Standardize line breaks to CRLF. We've had several PRs where they caused issues.

Low priority long term plan: add new script to analyze index usage for SaaS clients

7

**Version of the script** 8.11 **What is the current behavior?** When you specify `@GetAllDatabases = 1` and `@TableName = 'something'`, a few weird things happen: * Script stops running if...

Fix typo

[Optimized Locking](https://learn.microsoft.com/en-us/sql/relational-databases/performance/optimized-locking?view=azuresqldb-current) adds some [new data points to a few system views](https://learn.microsoft.com/en-us/sql/relational-databases/performance/optimized-locking?view=azuresqldb-current#diagnostic-additions-for-optimized-locking). > Diagnostic additions for optimized locking > To support monitoring and troubleshooting of blocking and deadlocking with optimized...

**Is your feature request related to a problem? Please describe.** You can export data from XE files to tables in SSMS. This is often easier than trying to deal with...

sp_QuickieStore: See if dm_db_tuning_recommendations would make a useful addition.

3

**Is your feature request related to a problem? Please describe.** I'd like to see if this view has any generally useful information in it. It should be available in 2017+...

**Is your feature request related to a problem? Please describe.** The query that currently gets the procedure name based on object and database id can get real slow because it's...