Updates_20250601

What's Changed

• sp_QuickieStore: Appended _ms where it was missing for avg_cpu_time by @ReeceGoding in #600
• sp_QuickieStore: Moved validation of @sort_order to be much earlier on. by @ReeceGoding in #602
• sp_QuickieStore: Moved special sorting columns for special sort order values to be jus… by @ReeceGoding in #604
• sp_QuickieStore: Made plan hash, query hash, or sql handle show when the parameter for filtering them out is passed in by @ReeceGoding in #608
• sp_QuickieStore: Documents that @format_output = 1 removes most decimals. by @ReeceGoding in #606
• Adding support for indexed views in addition to indexes on tables. by @FirstCall42 in #610
• sp_QuickieStore: Move regression validation to just after sort order by @ReeceGoding in #612
• Made sp_HumanEventsBlockViewer not error out when system_health is used by @ReeceGoding in #618

Full Changelog: Updates_20250501...Updates_20250601

May Flowers

What's Changed

• fix for 00 decimals on avg_read/write_stall_ms and total_avg_stall_ms by @VladDBA in #567
• sp_QuickieStore's Readme.md file - Markdown needs the escape character escaped by @VladDBA in #572
• sp_QuickieStore: Consistent PRIMARY KEY syntax. by @ReeceGoding in #578
• sp_QuickieStore: Made skipping maintenance plans optional by @ReeceGoding in #580
• Expand wait_time_percent_of_uptime to accomodate >1,000% waits by @ChrisMayIVCE in #585
• sp_QuickieStore: Multiple changes to how wait stats are handled by @ReeceGoding in #590
• Made filtering by @execution_count be done with a temp table rather than a variable by @ReeceGoding in #593

New Contributors

• @VladDBA made their first contribution in #567
• @ChrisMayIVCE made their first contribution in #585

Full Changelog: Updates_20240404...Updates_20250501

4.4 @ 4:44

This release fixes a bunch of stuff that I found in deeper testing across different environments.

It also introduces a new stored procedure called sp_PerfCheck, which does a targeted set of checks for performance-related stuff only. No backups, no checkdb, no security, etc. It's built to work with Azure SQLDB too, which is... I guess sort of helpful, given how little you can change while running SQL Server in Safe Mode. I will be adding more specific checks for cloudy things in the future.

For now, check out the readme to learn more.

Also, give it a run. Let me know what you think. I care about your feelings.

What's Changed

• sp_QuickieStore: @utc_offset_string nvarchar(max) changed to nvarchar(6) by @ReeceGoding in #537
• Compression eligibility changes by @FirstCall42 in #549

New Contributors

• @FirstCall42 made their first contribution in #549

Full Changelog: Updates_20250401...Updates_20240404

Sweet Caroline!

What's Changed

• changed column name to remove duplicate by @DForck42 in #509
• added QUOTENAME to the output of the 'original_index_definition' colu… by @HannahVernon in #529
• added note about index_count column to the README.md by @HannahVernon in #530

There's no way to quickly or easily summarize this many changes, but:

sp_HealthParser:

• Added new event collections around errors, memory, and more cpu stuff
• Added the ability to log to tables
• Removed a lot of repetitive code by templating dynamic sql

sp_HumanEventsBlockViewer:

• Added the ability to log to a table. I know it's somewhat redundant to sp_HumanEvents, but it focuses purely on blocking and uses the final results from here rather than somewhat raw data with a view over it
• Added the ability to read from a table storing the blocked process report in an XML column

sp_PressureDetector

• Added table logging

sp_QuickieStore:

• Made the results query far less repetitive, no longer broken up over four sections of annoying to maintain code
• Pushed @include_query_hashes data deeper into the procedure so it's not just based on the results

AND THE BIG ONE!

sp_IndexCleanup

• No longer in beta!
• Reasonably functional, but still needs testing

Also fixed up some annoying formatting inconsistencies, etc. in various places.

New Contributors

• @DForck42 made their first contribution in #509

Full Changelog: Updates_20250101...Updates_20250401

Back to the Future

This is a long overdue release with bumped version numbers and dates, and some 2025-proofing of the copyright year on the main scripts. I'll get to the others eventually.

An extra special thanks goes out to @ReeceGoding for hump-busting on sp_QuickieStore.

What's Changed

• Update sp_PressureDetector.sql by @erikdarlingdata in #472
• Dev by @erikdarlingdata in #475
• Dev by @erikdarlingdata in #477
• Update sp_IndexCleanup BETA.sql by @erikdarlingdata in #478
• Update sp_IndexCleanup BETA.sql by @erikdarlingdata in #479
• Update sp_IndexCleanup BETA.sql by @erikdarlingdata in #481
• sp_QuickieStore and README.md: Clarified how @get_all_databases and @database_name work with system databases. by @ReeceGoding in #488
• sp_QuickieStore: Added ability to check for regressions. by @ReeceGoding in #486
• QuickieStore Examples: Minor wording edits. by @ReeceGoding in #491
• sp_QuickieStore: Made last_ columns report the actual lasts, rather than the maximum of them by @ReeceGoding in #492
• Validated @query_execution_type_desc's value. by @ReeceGoding in #494
• sp_QuickieStore: Add more examples to the examples file. by @ReeceGoding in #495
• Dev by @erikdarlingdata in #496
• Dev by @erikdarlingdata in #500
• sp_QuickieStore: Added ability to sort by average row count by @ReeceGoding in #499
• Dev by @erikdarlingdata in #501
• Update Isolation Levels.sql: Extremely minor typo fix by @ReeceGoding in #503
• Dev by @erikdarlingdata in #506
• Happy New Year by @erikdarlingdata in #507

Full Changelog: Updates_20240915...Updates_20250101

Somebody

Updates_20240915

Automation: Format and Build SQL File

Mr Tinkertrain

What's Changed

• Duplicate join condition and missing database_id conditions by @markkeyworth in #443
• Dev by @erikdarlingdata in #445
• Closes #450 by @erikdarlingdata in #452
• sorted the list of ignorable wait types by @HannahVernon in #453
• Dev by @erikdarlingdata in #454
• Update sp_PressureDetector.sql by @erikdarlingdata in #455
• sp_Quickiestore: Truncate #query_text_search_not if @Get_All_Databases = 1 by @ReeceGoding in #460
• sp_QuickieStore: Correct UTC offsets by @ReeceGoding in #458
• sp_QuickieStore: Add the ability to sort by arbitrary orders, but particularly wait stats and "plan count by hashes". by @ReeceGoding in #459
• Dev by @erikdarlingdata in #463

New Contributors

• @markkeyworth made their first contribution in #443

Full Changelog: Updates_20240619...Updates_20240901

2024_06_19

What's Changed

• Fix multiple file auto-format by @zikato in #410
• Update sp_QuickieStore.sql by @erikdarlingdata in #415
• Try to fix workflows by @erikdarlingdata in #416
• Make sp_QuickieStore early exit if the procedure searched for does not exist when using @get_all_databases. by @ReeceGoding in #413
• Dev by @erikdarlingdata in #417
• Update sp_HumanEvents.sql by @erikdarlingdata in #418
• Update README.md by @1DontEx1st in #419
• Dev by @erikdarlingdata in #421
• Update sp_HumanEventsBlockViewer.sql by @erikdarlingdata in #424
• Update sp_HumanEventsBlockViewer.sql by @erikdarlingdata in #425
• Dev by @erikdarlingdata in #427
• sp_QuickieStore: Added parameter to hide the bottom table by @ReeceGoding in #431
• sp_QuickieStore.sql: Moved capturing of _date_original variables outside of loop. by @ReeceGoding in #432
• Dev by @erikdarlingdata in #434
• Update sp_QuickieStore.sql by @erikdarlingdata in #435
• Update sp_QuickieStore.sql by @erikdarlingdata in #438
• Update sp_PressureDetector.sql by @erikdarlingdata in #439
• Update sp_PressureDetector.sql by @erikdarlingdata in #440
• Dev by @erikdarlingdata in #441

New Contributors

• @zikato made their first contribution in #410
• @1DontEx1st made their first contribution in #419

Full Changelog: Updates_20240408...Updates_20240619

Updates_20240408

What's Changed

• Update CONTRIBUTING.md by @erikdarlingdata in #400
• Dev by @erikdarlingdata in #401
• Dev by @erikdarlingdata in #402
• Update question.md by @erikdarlingdata in #403
• Dev by @erikdarlingdata in #404
• Update sp_PressureDetector.sql by @erikdarlingdata in #405
• Update sp_QuickieStore.sql by @erikdarlingdata in #406
• Test pull request by @erikdarlingdata in #407
• Dev by @erikdarlingdata in #408
• Rename by @erikdarlingdata in #409

Full Changelog: Updates_20240403...Updates_20240408

Updates_20240403

What's Changed

• Update sp_QuickieStore.sql by @erikdarlingdata in #394
• Dev by @erikdarlingdata in #396
• Update sp_PressureDetector.sql by @erikdarlingdata in #397
• Update sp_PressureDetector.sql by @erikdarlingdata in #398
• Update sp_PressureDetector.sql by @erikdarlingdata in #399

Full Changelog: Updates_20240401...Updates_20240403