Comments
Sort by recent activity
Thanks for the reply, Alex! I'll look into the code sample in the linked post when I'm in the office tomorrow. I have already followed your suggestion to post to Uservoice: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/34256914-customize-disk-space-alert-for-c-drive-on-all-ser
/ comments
Thanks for the reply, Alex!I'll look into the code sample in the linked post when I'm in the office tomorrow.I have already followed your suggestion to post to Uservoice: https://sqlmonitor.uservoi...
Thanks for the reply, Russell! Unfortunately, the PurgeSettings table for this customer is totally empty, which I assume is how you store "use factury default settings". And I obviously cannot add a row to it. [image] I'll probably have to do some manual purging. Can you point me to some tables that I can safely trim down a bit? The reason this customer decided to use Express edition is the phrasing on this page: https://documentation.red-gate.com/sm7/getting-started/requirements/hardware-and-performance-guidelines - I now found other pages where you are more explicit about not using Express but this page can defintely be interpreted as "you can use it, just purge a bit more agressive". (They are monitoring 11 instances across 9 servers). I'll talk to them about upgrading the instance to Standard Edition but my first priority now is to remove some data, restart the service. change the data purge settings, and then ensure that everything is working as it should once more. After that I'll try to find business cases for moving back to longer data retention. / comments
Thanks for the reply, Russell!Unfortunately, the PurgeSettings table for this customer is totally empty, which I assume is how you store "use factury default settings". And I obviously cannot add a...
I managed to get this solved myself. I noticed that there were windows of time where monitoring would temporarily resume so I figured that it does still purge data and then re-fill the free space. So I kept trying until today I managed to sneak in an update of the purge settings without getting an error. / comments
I managed to get this solved myself. I noticed that there were windows of time where monitoring would temporarily resume so I figured that it does still purge data and then re-fill the free space. ...
Hi Krzysztof,
After reading your message I tried if I can still reproduce it. I re-enabled the option to add a closing single-quote mark and tried what happens. And it does work as intended (and as it did previously) for me.
So I don't know if this wa a one-time thing, or if it is a sporadic on-and-off thing. I'll leave the option on and I'll let you know if it returns.
I don't know which logs I should check for this or where to find them. The only other SSMS extension I have is the SQL Sentry Plan Explorer plug-in, and I've been using that "forever".
Thanks for your reply. For now, you can probably consider this as fixed.
Cheers,
Hugo / comments
Hi Krzysztof,
After reading your message I tried if I can still reproduce it. I re-enabled the option to add a closing single-quote mark and tried what happens. And it does work as intended (and as...
Closing this because the error went away all by itself.
Thanks for looking into it! / comments
Closing this because the error went away all by itself.
Thanks for looking into it!
No problem, just let me know what you're thinking and I'll tell you how I read the message. / comments
No problem, just let me know what you're thinking and I'll tell you how I read the message.
Worked like a charm, Pete. Thanks for the quick response! / comments
Worked like a charm, Pete. Thanks for the quick response!
Hi James,
Thanks for looking into this. I am waiting for a vendor to come back to me with some quotes on replacement laptops so I will not be upgrading any software on this old wreck - but I will definitely jump to the newest versions once I get my new power-beast!
The issue with the reformatted SQL is that the list of colours in the IN list is syntactical incorrect, these are values and need to remain enclosed within [brackets]. Submitting the reformatted code will produce an error message.
EDIT to add: I know that changing the option fixes this, but regardless of the option the tool should never remove brackets that are non-optional.
Best,
Hugo / comments
Hi James,
Thanks for looking into this. I am waiting for a vendor to come back to me with some quotes on replacement laptops so I will not be upgrading any software on this old wreck - but I will d...
Huh? That's weird. I was certain that I got an error when I tried this the last time, but now it does run just fine.
The syntax diagram at https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx does seem to suggest that brackets are mandatory, and all the examples (for PIVOT, not for UNPIVOT) have them (but then, they all use numerical values, not strings, which SQLPrompt does indeed leave intact).
I looked a bit further, and the syntax diagrams at https://technet.microsoft.com/en-us/library/ms177634(v=sql.105).aspx show that the IN list is supposed to contain column names, and in that case I have to agree that "Black" and "[Black]" are both correct; this is not a bug after all.
Sorry for wasting your time!
Cheers,
Hugo / comments
Huh? That's weird. I was certain that I got an error when I tried this the last time, but now it does run just fine.
The syntax diagram at https://technet.microsoft.com/en-us/library/ms177410(v=sql...
I'm attending and speaking. A bit of a niche subject: instead of my usual performance talks, I will showcase some interesting Service Broker solutions I have worked over the years. Should be good! / comments
I'm attending and speaking. A bit of a niche subject: instead of my usual performance talks, I will showcase some interesting Service Broker solutions I have worked over the years. Should be good!