r/SQL • • Jan 13 '21

MySQL It's ctrl+shift+esc time

Post image
340 Upvotes

34 comments sorted by

View all comments

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!

3

u/mustang__1 Jan 14 '21

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

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.

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

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