Posts
Sort by recent activity
Various Formatting "Anomalies" - 9.1.0.4138 - Includes a HOWLING BUG
BUG FIRST
When a proc contains a large volume of XML in the form of a document with some string concatenations, SQL Prompt renders the code unreadable. It places elements of the statement out to c...
BUG! 7.1.18 - "OLDER" DOES NOT WORK ANY MORE!
Stunning, simply stunning...
Really don't want to have to resort to the "Wait a week for bugs to be reported before applying any SQM patches", but this is the straw that broke...
Neither from the e...
7.1.17 Cannot Count! Alerts show incorrect numbers.
This was true of the .16 build, too, but as it persists in the .17 build, here's the bug report...
The server tree shows one count, the X of Y shows Y as another count, then when scrolling to the l...
WHY is ReportServerTempDB the subject of IRRELEVANT Alerts? Ditto tempdb?
Why is ReportServerTempDB ever shown as "Backup Overdue"? According to MS it's SSRS's equivalent of tempdb, and is re-created each time SSRS fires up.
Surely it can be excluded from ANY and all of...
7.1.15.10321 - Job Failing NOT TRIGGERED for a DBCC Fail
Kind of an important one to NOT be alerted to by ANY means - Alert or email...
The SQL Agent Job Failing alert is configured to raise as RED and email the DBATeam@ address.
SQM fell SILENT.
SQM did...
gMSA's Appear UNSUPPORTED at Server Component Install Time!
Just downloaded the latest DBA Bundle (on Jan 16th, 2018) and although the server component installer appeared to correctly recognize that SQL is using a gMSA, therefore disabled the password contr...
BUG: V9.0.1.3179 - Out-of-Memory Exception multiple times, SSMS did crazy things
With the default of "Enable Code Analysis" checked, SQL Prompt causes SSMS OOM Exceptions, repeatedly.
The worst occurrence:
Pasted a table-name in a tab that I'd been using for sp_blitzindex, and...
REMOVED - Not a SQP Issue
Apologies. Have found all Text Editor settings missing from SSMS 2017 - not just a SQP Issue.
9.1.3.90 - Network retention applied to Local retention
ONE of the 11 User databases has started to keep local backup files beyond the 8 days stipulated - more in line with the network retention of 31 days (as in, 25 days and counting). No job changes ...
Bug? Ctrl+B, Ctrl+Q assigns same alias to both parts of the JOIN
Version 7.3.0.775UPDATE uvu
SET IncludeInVersionResult = 0
FROM #UniqueVersions uvu
WHERE VersionNumber <> 1
AND PromotionID IN ( SELECT P...