improve performance in SSMS when CTE statements are in the script
Or maybe an option to disable parsing of statements using CTEs. My keyboard takes seconds to respond when several CTEs are in the script.
5
votes
tkdennis
shared this idea
We’ve just released SQL Prompt 6.1 which shouldn’t slow down typing when CTEs are used
-
Adam
commented
Same here. Performance comes to a crawl if I have a bunch of CTE's in my proc. Disabling Code Suggestions completely eliminates the performance hit, but of course that's like turning off the software. I do that temporarily so at least I can write the code, but not a long term fix. I'll eventually go with another software solution if that can't be resolved.
I could even live with an option of not parsing the CTEs if necessary. Just don't make my computer act like a 486 processor when I got work to do.