Activity overview
Latest activity by LSZ
Hi,
All right, I'm looking forward to next build(s), because the build that I'm using now expires 2013-09-30 [image]
Regards,
LSZ / comments
Hi,
All right, I'm looking forward to next build(s), because the build that I'm using now expires 2013-09-30
Regards,
LSZ
Hi,
sorry that I haven't been participating in this thread for a long time, but I was quite busy at work. In fact while working I was testing this unstable release that Aaron posted and I hold the opinion that it's better and even on larger scripts it's not being so sluggish.
I would like to share few of my observations: 1. Suggestions box is still taking some time to show up on my large database, maybe because of the RegEx feature that is searching for the match in table names etc. ? 2. We are using a lot of XML in my company, eg.
;WITH XMLNAMESPACES
(
'http://tempuri/targetns/v3' AS tns
)
SELECT
t_si.position,
row.value('./something_1', 'VARCHAR(50)'),
row.value('./something_2', 'DATETIME'),
row.value('./something_3', 'INT')
FROM
@someItems t_si
CROSS APPLY @XMLVar.nodes('/tns:root/list/relatedItem[position()=sql:column("t_si.position")]') T1(row)
maybe this is the case ? 3. The table variables (DECLARE @t_name TABLE...) are not showing up in suggestions box. 4. In my error log I am seeing such entires:
30 Aug 2013 08:09:44,995 [Main] WARN RedGate.SQLQueryKeeper.TabWatcher - Exception trying to log MostRecentView information
System.Runtime.InteropServices.InvalidComObjectException: COM object that has been separated from its underlying RCW cannot be used.
at #B4sb.#D4sb.#gCSb()
Aaron, when you are planning to release the stable version ?
Regards,
LSZ / comments
Hi,
sorry that I haven't been participating in this thread for a long time, but I was quite busy at work. In fact while working I was testing this unstable release that Aaron posted and I hold the ...
Aaron,
It's way better than previous versions (after 3.9).
I gave it a try with the same scripts and database that previous versions were struggling with and now It's not sluggish. Still I wish it could be faster with displaying suggestions, but as I said - it's way better so your team is on the right path.
I think I'll work with this version a little longer and if I encounter any problems I will write about them here.
Thanks for your efforts,
LSZ / comments
Aaron,
It's way better than previous versions (after 3.9).
I gave it a try with the same scripts and database that previous versions were struggling with and now It's not sluggish. Still I wish it ...
Great news!
I'm really looking forward to downloading this new build. / comments
Great news!
I'm really looking forward to downloading this new build.
Some additional counts:
SQL_SCALAR_FUNCTION = 386
SQL_STORED_PROCEDURE = 7943
SQL_TABLE_VALUED_FUNCTION = 71 / comments
Some additional counts:
SQL_SCALAR_FUNCTION = 386
SQL_STORED_PROCEDURE = 7943
SQL_TABLE_VALUED_FUNCTION = 71
Manfred,
I don't think I am allowed to share our company's proprietary database schema, but I can give you some "metadata", such as:
1. count of user tables in dbo schema (this is the only schema that we use) is 2751
2. count of all columns in user tables is 28933
If you need some more information please ask.
Regards,
LSZ / comments
Manfred,
I don't think I am allowed to share our company's proprietary database schema, but I can give you some "metadata", such as:
1. count of user tables in dbo schema (this is the only schema t...
Hi Manfred,
I have latest drivers installed, my graphics is Intel HD Graphics 4000.
My laptop has Core i7, 8GB RAM and SSD.
Previously in my company we were using SQL Prompt 3.9 and recently we installed version 5.3 and since then SSMS 2008 and 2012 are extremely sluggish. The response time to keystrokes is not acceptable, we can't work with code suggestions enabled any more. The thing is, that when I change the context of the script to eg. master database, SSMS works great, so evidently there is a problem with databases with complex schemas.
I even installed Prompt version 6.0.0.168 and it is the same, extremely sluggish!
Please do something about it, otherwise we will be forced to go back to version 3.9 or try other products.
--
Regards,
LSZ / comments
Hi Manfred,
I have latest drivers installed, my graphics is Intel HD Graphics 4000.
My laptop has Core i7, 8GB RAM and SSD.
Previously in my company we were using SQL Prompt 3.9 and recently we ins...