I've found a major memory leak in SQL Complete for Sql Server, which requires me to restart SSMS quite frequently. The time varies, but sometimes SSMS memory usage grows to 1 GB within a few minutes, if I work on large enough files.
I frequently work with large files (~3000 lines or more) with very similar layout, and these seem to cause issues for SQL Complete. The format of these files is as follows:
Code: Select all
SET IDENTITY_INSERT Table1 ON;
INSERT INTO Table1 (Column1, Column2, ...)
SELECT Column1, Column2, ... FROM (
SELECT Value1_1, Value2_1, ... UNION ALL
SELECT Value1_2, Value2_2, ... UNION ALL
...
SELECT Value1_2999, Value2_2999, ... )
t (Column1, Column 2, ...)
WHERE NOT EXISTS (SELECT * FROM Table1 t1 WHERE t1.Column1 = t.Column1);
SET IDENTITY_INSERT Table1 OFF;