don v nielsen

Avatar

Avid fan of RubyMine and DataGrip.

  • Total activity 89
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 5
  • Subscriptions 28
  • Created

    Parsing error with SQLite FILTER() without OVER Window

    Answered
    The following image shows a language parsing error related to the filter() function. The error appears when there is no accompanying OVER window function definition. The SQL executes fine, An OVER...
    • 2 followers
    • 2 comments
    • 0 votes
  • Created

    How does my use of DataGrip affects a DBA's ability to do his/her job?

    Answered
    My boss has said that the company DBA has asked me to stop using DataGrip to connect to the databases (Sql Server.) No reason was given, and asking why in an email has been met with no response. So...
    • 3 followers
    • 5 comments
    • 0 votes
  • Created

    2019.2.2 autocomplete...any complaints. Failing miserably.

    Completed
    Updated datagrip to 2019.2.2 from 2019.2.1. Autocomplete is failing. This is build db-192.6262.49. I have close the app and restarted. That did not help.  I have refreshed my schemas. That has not...
    • 2 followers
    • 2 comments
    • 0 votes
  • Edited

    SQL Server DDL Discrepancy between DataGrip and SSMS

    I have a table in SqlServer. Using DataGrip, it generates the following DDL. Note the StopDate, StopDateFrom, and StopDateTo columns; they implement a user defined type Date_NONULLS. create table t...
    • 3 followers
    • 14 comments
    • 1 vote
  • Created

    File and Scratch Views

    The DataGrip documentation talks about two views: File View and Scratch View. It shows that scratch files appear under the Scratch tab of the view. I cannot figure out how to get my view to look l...
    • 2 followers
    • 3 comments
    • 0 votes
  • Created

    Unresolved column on delete statement

    FYI - After updating DataGrip this morning, I noticed that a column is highlighted as unresolved on the DELETE statement. It is ok in the prior SELECT and following INSERT statements. It is just un...
    • 3 followers
    • 2 comments
    • 0 votes
  • Created

    Have project remember Save As Folder

    Given a project and multiple scratch files When I go to "Save As" to save the scratch file to a permanent folder Then DataGrip should remember, for the project, the last folder saved to   Datagrip ...
    • 2 followers
    • 1 comment
    • 0 votes
  • Edited

    Interesting observation about the DG performance of two queries

    Below are two queries. They do the same thing, and both result in 0 rows. The result is correct. So...from DataGrip...the first query consistently returns results in less than a second. Time and ti...
    • 1 follower
    • 0 comments
    • 0 votes
  • Created

    Suggested table list does not regain focus

    Try this in a console window: Start typing a select statement Give it a FROM domain.dbo. and stop there. It will bring up a list of suggested tables. Highlight a table, any table (do not dbl click...
    • 1 follower
    • 0 comments
    • 0 votes
  • Created

    Console Scratch File Name Enumeration

    Would it be possible to continue console scratch file name enumeration from the last scratch file present? I cleaned up a bunch of unused scratch files, #'s 1-8, leaving #'s 9-11. When I created a ...
    • 1 follower
    • 0 comments
    • 0 votes