Devart Forums

Thanks alexa, but that's not quite what I'm looking for. The client statistics in SSMS are stats about the statement from the viewpoint of the end client, rather then the server. It's useful for getting data from the end client perspective, taking into account network latency, etc., rather then what the server is doing.

SSMS has a feature to "Include Client Statistics" when executing a statement that will return things such as the number of statements executed, bytes sent and received, number of rows, etc.

Does dbforge have anything similar? Closest that I've found is the query profiler, but it only does estimates and the query plan, not the final stats.

When looking at a set of query results in the Grid View, is there an option to highlight and/or format any cells where the value is null? The default of italics helps, but I'm hoping to make those pop a bit more.

Just installed v5.5.369 enterprise, and have encountered a few issues with some of the web pages used for things like what's new and feedback.

During the install, I received an error about not being able to load the What's New web page. And if I use either the Help --> Leave Feedback or Help --> Suggest a Feature options, I get an error such as the following:

Windows cannot find
...://devart.uservoice.com/forums/177009-dbforge-studio-for-sqlserver?utm_campaign=ui_...
Make sure to typed the name correctly, and then try again.

Hi Alexa, I didn't get a chance to try the registry key you metioned. However, with the 5.5 release, is that key still valid, or should it be changed (possible with the version number updated)? Or does the 5.5 version have any bug fixes in it to address this issue?

Pretty basic for me. I just have a series of T-SQL windows open, with active connections to either one or 2 databases. Most queries will be SELECT statements, and will have had some data loaded.

Hi Alexa,
I've had that option turned off in my environment for a couple weeks now. Anecdotally, it feels like I'm experiencing the issue a little less, but it is still quite frequent, where in I'll have my window lock up a couple times a day.

I have a view that's made up of several rolled-up sub-select statements, and some of the lines of these sub-selects are wider than my current window size. When I open this view in dbforge, and look at the T-SQL tab, the side-scroll bar is "disabled", and I can't view the full width of my query. If I either collapse the part that the wide statement using the "-" boxes on the left side, or select the wide part of the query in the Document Outline, then the side-scroll bar enables itself, and I can move the window around to see the full width.

I'm sorry Alexa, but because it's a random issue that's hard to reproduce, I've haven't been able to work often with the setup you wish to have (2 instances open, one with the start up option set to "Show empty", the other not). However, I was just working today with a single instance open, with the show empty option set as the startup option, and encountered the same issue.

Please let me know how you'd like me to proceed/continue testing.

Glad to see I'm not the only one experiencing this.
Just some follow ups from my side.
While the end result is the same (program unresponsive), I am seeing slightly different behavior at times. In particular, there are some occasions when my open tabs restore, and in others none of them are restored. As well, most of the time I can close the program from the task bar. However, usually if I try to interact with it in some way (ie. try to use the restore and/or maximize functions), the dbforge will lock up "harder", and I'm forced to use task manager to kill it. I've also found that when it reaches this state, dbforge becomes an "always on top" app, and I can't interact with any other program windows that are underneath it until I close it.

As for query types that I'm working with, for the most part they are simple selects, possibly with a join condition or two, and maybe some sum/groupings. I've had it occur with only a couple tabs open, or with 10 tabs. I can't recall any particular instance in which I've let queries run in the background before trying to restore, but I can guarantee that the issue has occurred when there are no background queries running (it just happened to me again).

As for options set in dbforge (in case it helps), I can't recall every having customized my environment, so whatever setting are used out of the box are probably what's set. I can send an export of my environment settings if it helps.

Thanks Alexa,
Same thing just happened to me. Had 5 or 6 SQL tabs open with various code snippets. I had left the program alone for over an hour. Probably had locked and unlocked my system a couple times during this, as well as using other programs. Attempted to come back into the program, and it was unresponsive. No windows chimes however this time. Was able to close the program using the taskbar close option, but I lost all my open tabs.

Let me know if there's anything else I can provide. I'm liking the program, just wish it ran a little better for me.

Does dbForge have a method that will allow me to connect to an on-premise SQL Server instance using a different set of Windows credentials than the ones that I'm currently logged in with? I've tried 2 windows based methods, but neither are ideal:
1) Using Run As / Run as Administrator: Doesn't actually work as my dbForge licensing information isn't carried through.
2) Creating an alternate set of credentials in the Credential Manager: Doesn't allow me to pick which set of credentials I want to use. I'd have to constantly create and remove the credentials from the Manager to switch between accounts.

Just occurred again, so I'll do my best to answer your questions:
1) Unfortunately not, as it seems random, and I can't re-create the issue on demand.
2) Program was open with 3 different SQL tabs open. I do believe that I had minimized it to the taskbar
3) Yes. Attempting to re-open it gives me a standard windows error "chime", and the window does not restore.
4) Not sure what you mean by tasks
5) Combination of programs: Google Chrome, RDP, TOAD, Windows Snipping Tool, Outlook, Excel, Skype 4 Business, Windows Explorer

I had also locked my system and gone to lunch between when I last interacted with dbForge, and when I tried to use it again.

I recently purchased dbForge Studio for SQL Server Enterprise. I'm enjoying working with it, and am finding great use of it's various tools.

That said, I am frequently finding that as I switch between it and other applications I have open, it frequently enters a state where it becomes unresponsive. I end up having to close the windows from the task bar and then re-start the application to get it to be usable again.

I'm currently running the latest build of Windows 10 (1703, build 15063.296), with .NET up to date. Any thoughts on what I might be able to do to resolve this? Or any options/logs I can provide to help you guys troubleshoot it?

Hi Alexa,

I just updated to the most recent build (5.4.275 express), and see that all my tables are now prefaced with the schema name.

Thanks for this. It really helps. Reviewing the change logs though, I never saw it mentioned.