I'm using SSMS 2017 and have an issue that means as soon as I have even a small number of rows (10,000)the user experience lows down. I do have Redgate SQL tools installed, but colleagues have the same setup and do not see the issue.
If I have a large number of rows, 100K plus then the system is unusable and sometimes even hangs or crashes.
Has anyone else had this issue and more importantly have any suggested fixes. I have uninstalled and reinstalled the app and also checked memory usage which is low. The data is not that large really, just SSMS has a bit of a hissy fit. 1 row of data Any thoughts appreciated.
regards, Anthony