A new IDE for SQL Server?

Question

Post reply

A new IDE for SQL Server?

Phil Factor

SSC-Insane

Points: 20244
More actions
June 12, 2010 at 11:24 am

#157014

Comments posted to this topic are about the item A new IDE for SQL Server?
Best wishes,
Phil Factor

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

sjsubscribe SSCrazy Points: 2080 More actions · Answer 1

"SQL Server Management Studio (SSMS) is a victory of ingenuity and energy..."

Thanks for a good laugh. I always thought of SSMS as a mobile home attached to the space shuttle.

Phil Factor SSC-Insane Points: 20244 More actions · Answer 2

Yes, it is what we Irish call a 'Donkey's breakfast'. The individual ingredients are good, but all stirred up together into a strange mash from which it is hard to pick out the raisins.

Best wishes,
Phil Factor

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

Phil Factor (6/13/2010)
Yes, it is what we Irish call a 'Donkey's breakfast'. The individual ingredients are good, but all stirred up together into a strange mash from which it is hard to pick out the raisins.

Ummm.... careful... those aren't raisins. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Wayne West SSC-Insane Points: 22586 More actions · Answer 4

There's a reason why I like also having the old Query Analyzer from SS2000 still around, I just wonder how much longer it will work with future versions of SQL Server.

-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 5

Wayne West (6/13/2010)
There's a reason why I like also having the old Query Analyzer from SS2000 still around, I just wonder how much longer it will work with future versions of SQL Server.

A sharp knife is more useful than a plasma cutter for most jobs.

Steve Jones - SSC Editor SSC Guru Points: 736193 More actions · Answer 6

As much as I didn't like the MMC move from Enterprise Manager, I think SSMS was a mistake. It's got too much built in, with hidden non-modal windows getting lost, and a pain to navigate through things.

I'd rather have us move back to separate tools for separate functions.

Wayne West SSC-Insane Points: 22586 More actions · Answer 7

Steve Jones - Editor (6/14/2010)
As much as I didn't like the MMC move from Enterprise Manager, I think SSMS was a mistake. It's got too much built in, with hidden non-modal windows getting lost, and a pain to navigate through things.
I'd rather have us move back to separate tools for separate functions.

The window popups are what really bugs me. Plus, when you maximize one window, then close it, SSMS doesn't remember that it was maximized when it was open 1 minute earlier.

I've thought about checking out Toad, but I obviously haven't thought too much about it as I haven't done it yet.

-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

WayneS SSC Guru Points: 95460 More actions · Answer 8

Two things frustrate me about SSMS:

1. Intellisense gets in the way to the point I've got it turned off.

2. When working with a dual-monitor system, with SSMS on the secondary monitor, all dialog boxes pop up in the center of the main monitor instead of the current one.

And a few irritations:

1. Many dialog boxes don't display the proper cursor.

2. The default action for a linked server is to open the properties dialog... but double-clicking it just expands that node in the treeview.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Adam Gojdas SSCommitted Points: 1766 More actions · Answer 9

'M' is a name already taken for a language. M is the name for the language once called MUMPS.

http://en.wikipedia.org/wiki/MUMPS

sjsubscribe SSCrazy Points: 2080 More actions · Answer 10

Adam Gojdas (6/14/2010)
'M' is a name already taken for a language. M is the name for the language once called MUMPS.
http://en.wikipedia.org/wiki/MUMPS

Yes indeed, and after looking Quadrant screen casts using M, it seems to run just like MUMPS -- same speed, only with prettier windows.