Activity overview
Latest activity by HugoKornelis
BUG: "Format SQL" introduces syntax errors
Hi all,The code below, though ill-formatted, is correct and works without error in SQL Server 2022:
SELECT frsx.ProductKey,<br> SUM (CAST (frsx.ShipDateKey AS bi...
Also, WOW! Those code samples, pasted in using the "Code" format, are really totally displayed wrong! / comments
Also, WOW! Those code samples, pasted in using the "Code" format, are really totally displayed wrong!
IGNORE NULLS and RESPECT NULLS not recognized for LAG and LEAD
Hey all!Today I noticed that SQL Prompt seems to be blissfully unaware of the new IGNORE NULLS and RESPECT NULLS optional keywords for the LAG and LEAD functions. However, when used with FIRST_VALU...
"Format SQL" fails on query hint
Don't know if this is due to a recent upgrade, or due to a specific query. But here are the steps to reproduce.(My configuration: SSMS 19.2.56.2; SQL Prompt 10.14.3.4664; SQL Server 2022, RTM-CU8-G...
SQLPrompt doesn't recognize "rollup" as reserved word
I have set SQL Prompt to automatically remove those [silly] and [[[useless]] [brackets]]]] where possible. Great with inherited code...However, I just ran into a situation where this causes an erro...
Breaking bug in SQL Prompt
SELECTHi!I just ran into a dangerous bug in SQL Prompt, where it changes my code instead of merely reformatting it. I am running 9.5.12.10845, which I think is the latest build. The repro code belo...
How to find out why SQLMonitor cannot access (some) data
One of my clients uses (on my suggestion) SQLMonitor to monitor their production databases. On one of the servers (incidentally the server that hosts the SQLMonitor database itself) I always see a ...
Don't check Agent status for Express Edition
Whenever I add a server to the monitoring that is Express Edition, I get alerted that the SQL Agent service is not running.Well d'uh. It's Express Edition. The Agent service cannot run on it.Instea...
Several questions
Hi all!I have a few questions on SQL Monitor. They are unrelated; I hope combining them in a single post is not too much of a burden? Let me know if you prefer me to take down this post and re-post...
RECOMPILE appears to prevent query capture
I'm trying to investigate the root cause of a very long running data load of the DW server. But even after allowing it to run to completion, the "TOP 50 QUERIES" list does not show any of the offen...