Yeah, okay, so I looked at it again for all of about two seconds, and you
know what? I still *hate* it. I *will* not use the Query Analyzer for
anything I don't absolutely have to. It simply doesn't work the way I
think. While I can make my way through it when necessary, it slows me down
significantly just to have to wrap my head around how it's trying to force
me to work, and I certainly can't afford that kind of time right now.
I've been working with SQL EM for about 3 years now, and STILL prefer the
View designer over QA. It's not like I'm a total noob or something.
So having established that, can we please get back to my original question
or perhaps provide me with a forum in which someone can help me. All this
"what? nobody uses that!" attitude is really very irritating.
I realize my irritation isn't likely to make me any friends, but imagine if
someone told you when you were asking for help with your word processor that
hand-writing a 1000-page report was really the best way to go because you
have so much more freedom in how the characters look and being able to put
drawings on it at will, etc. Not only would you think they had it
backwards, you'd be PO'd at the lack of help with your problem (as I am).
While I realize you all may look at this in reverse and think I'm the one
who's hand-writing while you're using the word processor, it's not helpful
no matter HOW you look at it.
Thanks,
Rob
"Robert Morley" wrote in message
news:%%23NX88V7zHHA.5160@TK2MSFTNGP05.phx.gbl...
> Well, I can give it a try, certainly, but my previous experience has not
> been that it wasn't particularly useful to my style of working.
>
> In the end, though, I still have to wonder why the oddities are occurring,
> regardless of which tools are better for the job.
>
>
>
> Rob
>
> "Nancy Lytle"
hotmail.com> wrote in message
> news:uevEeD7zHHA.3600@TK2MSFTNGP04.phx.gbl...>>I orginally started out in MS Access, so when I began using SQL Server, I
>>also mostly used the EM query process because it was so familiar, looking
>>as it does like the Access query builder. But as I became familiar with
>>Query Analyzer's abilities and the shortcuts it provides, I started using
>>it more and more. It is really a matter of getting used to the change in
>>format and becoming used to the tool.
>> By the way, you can drag columns individually in QA, you don't have to
>> drag the whole list unless you need it. So essentially you have the same
>> drag and drop ability, the only thing missing is the graphically
>> interface.
>> You might want to google for other graphical SQL Server query tools that
>> might work more to your style, etc.
>>
>> Nancy
>> "Robert Morley" wrote in message
>> news:%%23wuesg6zHHA.5476@TK2MSFTNGP03.phx.gbl...
>>> Neither of those features is particularly helpful to me, as most of the
>>> Views I create are subsets of the columns in a table, as well as subsets
>>> of the rows. So I'd spend almost as much time deleting text as I would
>>> entering it in the first place, and the View designer offers the ability
>>> to create INSERT and UPDATE queries as well in what I consider to be a
>>> much more designer-friendly format (with some limits, admittedly, as it
>>> can't handle DELETE/UPDATE queries with joined tables, for instance).
>>>
>>> If everyone here uses the QA for some reason which is totally beyond me,
>>> is there somewhere that I *can* ask these questions? Surely there must
>>> be SOME others out there who feel, as I do, that the View designer is
>>> far more useful for their tasks than the QA is...otherwise, there
>>> wouldn't BE an Enterprise Manager.
>>>
>>>
>>>
>>> Rob
>>>
>>> "Roy Harvey"
snet.net> wrote in message
>>> news:tmvga3hluhom15uoisoj2mtmlriiaepi9h@4ax.com...>>>> On Wed, 25 Jul 2007 21:24:35 -0400, "Robert Morley"
>>>> wrote:
>>>>
>>>>>Even though I type at about 80 wpm, I think the slowness of typing
>>>>>things in
>>>>>the QA would outweigh the once-per-load/save slowness in the View
>>>>>designer.
>>>>>I also "think better" when I've got the grid to look at, so I don't
>>>>>consider
>>>>>the QA a viable option. (Besides, at 3Mbps down/800kbps up, our VPN
>>>>>isn't
>>>>>THAT slow.)
>>>>
>>>> In general you will not get much help in the newsgroups with the
>>>> "builder" tools in EM because pretty much none of the people who share
>>>> their experience here use them.
>>>>
>>>> Perhaps you are not familiar with some of the finger-saving features
>>>> built into Query Analyzer. For example, click down into the tree to a
>>>> table, expand the table, then drag the Columns word to the window
>>>> where you are working. It will drop the list of all the columns in
>>>> the table, delimited by commas. Or right click on the table name in
>>>> the tree and choose to scrip the object as a SELECT (or INSERT or
>>>> UPDATE, etc).
>>>>
>>>> Roy Harvey
>>>> Beacon Falls, CT
>>>
>>>
>>
>>
>
>
