Activity overview
Latest activity by BiestMode
I will do that today; it is getting stuck on the loading parameters step. Like I said we ran SQL profiler on the different version of SQL prompt. The query I referenced in my first post is selecting the entire object text of every procedure in the database and is taking 5+ minutes to complete and does not appear at all in the older version. / comments
I will do that today; it is getting stuck on the loading parameters step. Like I said we ran SQL profiler on the different version of SQL prompt. The query I referenced in my first post is selectin...
SQL Prompt Refreshing very slowly, different query when connecting to DB
Hello, we've got quite a few complaints about slowness in a recent update of prompt. I've got some notes below on what I've found so far trying to troubleshoot this issue.We have some workstations ...
@Jon_Kirkwood I am also experiencing this same issue. We've got some workstations with Prompt 10.14.21.9884 and others on 10.14.23.11448. We're on the same network connected to the same database. When you refresh suggestions on the system running 10.14.23.11448 prompt is querying the object definition for all stored procedures which takes some time to run. Doing the same thing on the older copy of prompt does not do this. This is the query in question we see running on the newer version. SELECT obj.id AS object_id, OBJECT_DEFINITION(obj.id) AS object_definition FROM (VALUES ... / comments
@Jon_Kirkwood I am also experiencing this same issue. We've got some workstations with Prompt 10.14.21.9884 and others on 10.14.23.11448. We're on the same network connected to the same database. W...