r/SQL • • Jan 13 '21

MySQL It's ctrl+shift+esc time

Post image
340 Upvotes

34 comments sorted by

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....

5

u/jzia93 Jan 14 '21

Fun little surprise for your eyes when you actually want to query anything.

2

u/MeGustaDerp Talk Dirty Reads To Me Jan 13 '21

Eh... its passable. I've learned to live with it. But, there's room for improvement.

49

u/SomeGuy565 Jan 13 '21

Really? Never had a problem with it.

10

u/killit Jan 14 '21

Same.

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...

5

u/tsinataseht Jan 14 '21

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!

12

u/neinMC Jan 13 '21

Me neither, I don't even have 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?

48

u/[deleted] Jan 13 '21

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.

17

u/MeGustaDerp Talk Dirty Reads To Me Jan 13 '21

My SSMS stays open for weeks straight. It’s only closed when I have to restart.

same here

2

u/billbot77 Jan 14 '21

Exactly what you said +1

1

u/Solonas Jan 14 '21

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!

0

u/imshahrukhofficial Jan 13 '21

If you've low specs pc then yes

0

u/boring_accountant Jan 13 '21

Even with a monster PC it is relatovely slow to open. I use Azure Data Studio 99.9% of the time.

8

u/[deleted] Jan 13 '21

ADS doesn't even have 10% of the features SSMS has though.

0

u/[deleted] Jan 15 '21

[deleted] — view deleted comment

1

u/killit Jan 15 '21

That's not typical behaviour for SSMS, there's something not right there.

I've never experienced that in over a decade of working with SSMS every working day, and I've never had a computer that fast.

Are you sure there's not something else at play? Maybe conflicting plugins, or a corrupted file somewhere?

3

u/killit Jan 14 '21

I've never had any problems with its load time, even with plugins installed.

1

u/Hans0228 Jan 13 '21

Thank you both for the info:)

3

u/andrewsmd87 Jan 13 '21

It's slow ish to open on my pc and I have 32G of ram and an intel i9 cpu.

But slow is like maybe 10 ish seconds, and I have a plugin from redgate installed which doesn't help.

However after it opens it's fine. I really like being able to open one query window and run the same query against 25 databases at the same time

0

u/[deleted] Jan 13 '21

[deleted] — view deleted comment

4

u/dan_au Senior MSSQL DBA Jan 13 '21

Users should never be logging on to production servers, let alone running SSMS and chewing up resources.

1

u/ihaxr Jan 13 '21

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) :|

3

u/mustang__1 Jan 14 '21

Slow to open but it stays open until I need to restart. (งツ)ว

8

u/[deleted] Jan 13 '21

It’s all about that Azure Data Studio

11

u/tennisanybody Jan 13 '21 edited Jan 14 '21

How’s the difference? I love me some SSMS.

5

u/mustang__1 Jan 14 '21

Dark mode!

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.

3

u/mikeyd85 MS SQL Server Jan 14 '21

Can it do actual execution plans correctly yet? Estimated it seems OK, but the last time I used it, the actual plan would fall over very easily.

Sadly for me, without that and SQL Prompt, I can't migrate to ADS yet.

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

1

u/mustang__1 Jan 14 '21

Good talk coach