Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #491

Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround?

Show all headers | View raw

I was afraid this was the answer.  There are a lot of shortcomings,
but that fact is that clients like the Designer.  Redgate solves the
Designer's annoying habit of absolutely destroying the format of the
code, which makes the idea of flipping between the designer and code
tweaking very attractive.  I think the biggest shortcomings of the
designer are:

1. Incredibly horrible formatting of the code, including crazy over
use of parenthesis in the WHERE clause.
2. Designer often puts filter in the wrong place.  On OUTER joins, at
least one of the filters often belong in the join, not the WHERE.
ASFAIK, the Desginer will always put it in the WHERE (not talking
about cases where it puts the filter in a HAVING with GROUP BY).
3.Weak support for CTE's
4. No support for analytic functions.
5. ANY use  of the TOP operator.  I am not sure that operator should
even exist at all, and the tool should certainly not add it to
queries.

Has anyone heard if the Designer will be improved in Denali?


Thanks,

Bill





> Yes, don't use the Query Designer. It's a piece of crap. For reasons
> you just have discovered. There are plenty of constructs it does not
> support. It tends to put in TOP(100) PERCENT ORDER BY in view definitions
> which is useless. It also has quite funky formatting of the queries.
>

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SSMS Query Designer chokes on ANSI Analytic Functions.  Any Workaround? bill <billmaclean1@gmail.com> - 2011-07-01 11:17 -0700
  Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? Erland Sommarskog <esquel@sommarskog.se> - 2011-07-01 23:17 +0200
    Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? bill <billmaclean1@gmail.com> - 2011-07-02 01:05 -0700
      Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? Erland Sommarskog <esquel@sommarskog.se> - 2011-07-02 10:30 +0200
        Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? bill <billmaclean1@gmail.com> - 2011-07-07 12:05 -0700
    Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? "Fred." <ghrno-google@yahoo.com> - 2011-07-04 16:31 -0700

csiph-web