Forum Replies Created

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

  • Reply To: Malleable Source Control

    That's a good summary. We tend to hear "migration vs state" model (however less and less). Database development are more like both.

    I love SSDT for the state-based approach and script...

  • Reply To: Common Table Expression Misunderstandings

    jcelko212 32090 wrote:

    The name common table expression comes from the way that you factor it out of multiple positions in a query expression and move it to the front. By analogy,...

  • Reply To: Common Table Expression Misunderstandings

    Jeff Moden wrote:

    BWAAAA-HAAAAA! 😀  Let's not because then someone would want to rename iTVFs as PDIVs (Parameter Driven Inline Views). 😀

    (THUMBS-UP) If it helps to leave the misconception behind, I'm on...

    • This reply was modified 1 year, 7 months ago by  f.clems. Reason: Emoji not working
  • Reply To: Common Table Expression Misunderstandings

    With such a name, CTE were kind of made for misconceptions. Could we rename them LVR (Local View with Recursion)?

  • Reply To: Do it. Try it. Fix it.

    Ok tricks and manipulation were surely not appropriate. Pfiou... clear commutation really is an art.

    Thanks for the advice. Sincerely. Food for thought at an appropriate time here.

  • Reply To: Do it. Try it. Fix it.

    Sergiy wrote:

    F.clems, if you need to use tricks and manipulation to bypass the system in order to get a good result, then the system is broken, don't you think?

    I tend...

  • Reply To: Do it. Try it. Fix it.

    Jeff Moden wrote:

    , they still are a part of the problem.  It's just that they (we, actually) stand no chance of getting better if they keep getting told things like "Just...

  • Reply To: Do it. Try it. Fix it.

    Ok, that is not the full development cycle. And I associated fix it with improve it. I spend my time in a system created out of an ORM reproducing inheritance...

  • Reply To: Do it. Try it. Fix it.

    It may all come done to the interpretation, but this cycle seems perfectly relevant.

    Do it: get the first draft implementation. I'm to often locked in meeting on how should it...

    • This reply was modified 1 year, 8 months ago by  f.clems. Reason: Clarify I'm breaking things in DEV
  • Reply To: Getting started with the SQL MERGE statement

    The bugs daveBoltman mentioned is what keep me away from merge. It has had such a bad press. Has it recently changed? I would love to love merge, but this makes...

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