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:
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. ?
We are using a lot of XML in my company, eg.
- Code: Select all
'http://tempuri/targetns/v3' AS tns
CROSS APPLY @XMLVar.nodes('/tns:root/list/relatedItem[position()=sql:column("t_si.position")]') T1(row)
maybe this is the case ?
The table variables (DECLARE @t_name TABLE...) are not showing up in suggestions box.
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.
Aaron, when you are planning to release the stable version ?