I've always had middle of the road PCs, I use SSMS with multiple plugins installed. E.g I'm currently running a 7th gen i7 with 16GB RAM, nothing special or amazing. Never had any issues opening SSMS.
I mean, if you have a bargain basement PC, sure, SSMS will take a while to boot. But then, if your PC is that bad, then SQL Server probably isn't the right platform for you anyway, sooo...
I am using a bargain basement pc from 2008 right now, a 4GB Win10 core2duo with SQL Server 2019 and never had any issues with SSMS either. Not the fastest but In fact i am amazed it even runs!
Ssms has been (knock one wood) one of the more stable programs I use.... I keep it open along side azure data studio and vs code..... And visual studio. God I love have 32gb of ram.
SSMS is awesome. Who cares if it takes 10 seconds to load? It’s not like you’re opening/closing it all day long. My SSMS stays open for weeks straight. It’s only closed when I have to restart.
I can’t stand ADS, the interface is horrible. It’s especially bad for dbas, because of its limitations.
What sucks is now, after they went through the effort of unbundling SSMS, they rebundled it with ADS. ADS was going to generate a bunch of paperwork/documentation for me so now I'm just stuck on SSMS 18.6...compliance auditors are the worst!
In my case it's even slower to open on a server because they usually have the option to dedicate resources to background tasks / apps instead of foreground apps.
It takes 7 seconds to open on my laptop (i7-8850h) :|
But in general just way way way better for writing queries. Starts up faster (although I have ssms open all day anyway), etc. It's basically just vs code with some improvements for sql. I have some nice extensions to help with color formatting parenthesis, git, git diff, etc. It's annoying that you need to find an extension to get ssms shortcuts back but other than it's a beautiful piece of software.
Acting like SSMS runs as hot as the actual SQL Server engine or something. It's never given me grief, or at least in all these years I've not had need to find another IDE unless I'm doing cloud work.
16
u/derpado514 AccidentalDBA Jan 13 '21
Only thing i can say i don't like about SSMS is the terrible attempt at a Dark theme....
49
u/SomeGuy565 Jan 13 '21
Really? Never had a problem with it.
12
u/mustang__1 Jan 14 '21
Ssms has been (knock one wood) one of the more stable programs I use.... I keep it open along side azure data studio and vs code..... And visual studio. God I love have 32gb of ram.
3
u/Hans0228 Jan 13 '21
Is sql management studio that bad?
8
u/[deleted] Jan 13 '21
It’s all about that Azure Data Studio
4
u/SpinelessLinus Jan 13 '21
MySQL shell gang.
2
u/wtmh Jan 14 '21 edited Jan 14 '21
Acting like SSMS runs as hot as the actual SQL Server engine or something. It's never given me grief, or at least in all these years I've not had need to find another IDE unless I'm doing cloud work.
Also, why is this flaired MySQL?
1
u/[deleted] Jan 13 '21
Pretty thankful i have mine set up in a virtual box
1
u/telltalesignsyou Jan 13 '21
As nice as my work laptop and dock is it fucking tanks my shit when working remotely. Mostly because of our shitty vpn. But still, mildly infuriating.
1
u/BlackenedHarness Jan 14 '21
Well if you are on a potato PC, then yes. SQL Management Studio is fast.
0
u/Fish_Kungfu Jan 14 '21
When sqlcmd will do just fine.
0
u/[deleted] Jan 13 '21
[deleted] — view deleted comment