Reece Goding

Results 17 issues of Reece Goding

`autoplot` looks like great fun to play around with, but I see two major issues: 1. Little help for it seems to be easily available online 2. The documentation contains...

documentation
help wanted :heart:

Added SOS_WORK_DISPATCHER to the Ignorable list. This fixes issue #9248. ## Please read -- recent changes to our repo On November 10, 2022, [we removed some bloat from our repository...

### Summarize Functionality [Reliable sources](https://www.sqlskills.com/help/waits/sos_work_dispatcher/) consider SOS_WORK_DISPATCHER a benign wait added in SQL Server 2019. Whenever I run `Get-DbaWaitStatistic` on a server on any 2019 or later version, more than...

feature
triage required

[The documentation for Trace Flag 7412](https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql?view=sql-server-ver16) claims the following > Starting with SQL Server 2019 (15.x), this trace flag has no effect because lightweight profiling is enabled by default. I...

I decided to clean up anything that bothered me in `sp_BlitzQueryStore` before beginning any serious work on it. These are largely style changes. Summary: 1. Minor edits to some comments,...

Although it's sometimes considered a bad idea to turn on Query Store for these databases, that doesn't justify telling people that they haven't done so.

While working on `sp_BlitzQueryStore`, I noticed that this was missing in `sp_BlitzCache`.

**Version of the script** `@Version = '8.19', @VersionDate = '20240222';` **What is the current behavior?** 'Gathering highest log byte use plans' prints twice. You can see this on [line 2186](https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/blob/dev/sp_BlitzQueryStore.sql#L2186C13-L2186C50)...

**Is your feature request related to a problem? Please describe.** I find that the "Unparameterized Query" warning in `sp_BlitzQueryStore` is useless. I have never encountered a case where it flags...

enhancement
sp_BlitzQueryStore

### Summarize Functionality Neither reading `Get-DbaDependency`'s documentation nor skimming its source code has made how it finds dependencies obvious. There are [many methods](https://www.sommarskog.se/sqlutil/SearchCode.html) for finding dependencies in SQL and none...

feature
triage required