Re: MDX - SQL confusion?

Tech-Archive recommends: Fix windows errors by optimizing your registry



I'm not an expert in both, but they are syntactically dissimilar, except for
the SELECT and FROM words that is...

I have heard from other employees at my company that going back to
relational design from dimensional design is difficult..

"ghines57" <ghines57@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6BFAA944-4544-474A-8701-E6591B47EEB6@xxxxxxxxxxxxxxxx
Hi,
I'm pretty much a jack-of-all-trades at work, but I'm looking at starting
to specialize a bit in SQL server. Right now I'm both SQL admin and data
warehouse designer. I'm okay at SQL, but very weak at MDX. In starting to
learn a bit more about MDX, but in doing so, I'm wondering if it will
impact
any SQL skills.
In other words, do any of you get the two mixed up when writing queries?
For experts in both, do you still have a little brain cramp when you need
to
switch between the two?
Thanks for any help.


.



Relevant Pages

  • Re: SQL
    ... > If you design right, you can *shift* much behavior to being data and ... > SQL is close to being Turing Complete. ... It is a bad habit of yours. ... If you're seriously suggesting that CRUD applications are equal ...
    (comp.object)
  • Re: Object-oriented thinking in SQL context?
    ... away from arrays and other non-OO data structures associated ... SQL is constrained to 'trivial' arrays. ... Design: Logical Design", 4th edition. ... Something analogous happens with database design. ...
    (comp.databases.theory)
  • Re: Why does 1:3 relationsihp require another table?
    ... Pro SQL Server 2000 Database Design ... > there can be a relation with NULLs in its tuples (hence 1NF models with ... > can only conclude that you do not believe Louis and Lewis are correctly ...
    (microsoft.public.sqlserver.programming)
  • Re: Why does 1:3 relationsihp require another table?
    ... correct design for the new real-world model. ... there can be a relation with NULLs in its tuples (hence 1NF models with ... Here's a good argument for not letting me represent Louis and Lewis by ... SQL is an attempt to implement relational algebra ...
    (microsoft.public.sqlserver.programming)
  • Re: bypassing some of the parameters in a parameter query
    ... >> Well, WHERE does work in design view, but having a lot of ANDs and ORs ... what is simple and direct logic in SQL View ... >> query to design view and see if it makes sense to you. ... >> Tom Ellison ...
    (microsoft.public.access.queries)