Forum Replies Created

Viewing 15 posts - 4,576 through 4,590 (of 8,731 total)

  • RE: Today's Random Word!

    eccentricDBA (7/28/2015)

    Ray K (7/28/2015)

    DonlSimpson (7/28/2015)

    SQLRNNR (7/28/2015)

    TomThomson (7/27/2015)

    SQLRNNR (7/27/2015)

    Revenant (7/27/2015)

    Ray K (7/27/2015)

    DonlSimpson (7/26/2015)

    TomThomson (7/25/2015)

    SQLRNNR (7/25/2015)

    outre-mer

    ultramar

    Montreal

    Expos

    Nationals

    GNATS

    Bites

    Bytes

    Reality

    fantasy

    Final

    Countdown

    July 28, 2015 at 10:25 am

    #1815487

  • RE: Introducing the Set-based Loop

    karlheinz.ulonska (7/28/2015)

    Thanks for your great article.:-)

    I have a problem with three “While”-loops and was searching for a better solution.

    Instead of using the “The problematic solution” now I use your “Set-based...

    July 28, 2015 at 7:09 am

    #1815387

  • RE: Introducing the Set-based Loop

    aswin.iyer91 (7/27/2015)

    Hi Luis,

    It was a interesting article though highlighting the perception that has been taken up for the RBAR and set based data traversing in SQL. The major thing which...

    July 28, 2015 at 6:58 am

    #1815384

  • RE: Introducing the Set-based Loop

    Michael Meierruth (7/28/2015)

    Luis,

    Why doesn't the GroupsHistory table have a ClientId column?

    Why this wierd hierarchy - which it really isn't? It's more like a series.

    To answer your first question, that table...

    July 28, 2015 at 6:54 am

    #1815382

  • RE: Introducing the Set-based Loop

    Jonathan AC Roberts (7/28/2015)

    I've got to say the first thing I thought as I got halfway through the article was "my god they need some indexes on those tables". You'd...

    July 28, 2015 at 6:35 am

    #1815373

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/27/2015)

    SQLRNNR (7/27/2015)

    Brandie Tarvin (7/27/2015)

    Pseudo-simple

    Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.

    Thanks for bring up the topic,...

    July 27, 2015 at 11:18 am

    #1815208

  • RE: Introducing the Set-based Loop

    SQLRNNR (7/27/2015)

    One niggle. The looping-set update is not technically RBAR since it is performing groups of set-based operations.

    That was exactly the point of this article, to differentiate RBAR from set-based...

    July 27, 2015 at 10:17 am

    #1815191

  • RE: Trying to Export data from sql server db 2005 to flat file and replacing null with ''

    That's weird.

    I suppose that it just stopped at the first semicolon. I generally avoid using "USE database_name" and that's probably why I've never encountered that problem.

    Thank you for sharing the...

    July 27, 2015 at 10:12 am

    #1815187

  • RE: Introducing the Set-based Loop

    GoofyGuy (7/27/2015)

    Terrific article, and thanks for it! It nicely shows how plan optimisation influences run-times and efficiency.

    Thank you for the feedback. 🙂

    July 27, 2015 at 9:45 am

    #1815173

  • RE: Trying to Export data from sql server db 2005 to flat file and replacing null with ''

    Are you pointing to the correct database/server?

    July 27, 2015 at 9:18 am

    #1815164

  • RE: Introducing the Set-based Loop

    Hi Sam,

    Thank you for reading the article and commenting. You're absolutely right, there's an error with the generation for the sample data. There shouldn't be a many to many relationship...

    July 27, 2015 at 8:14 am

    #1815144

  • RE: Finding the first credit balance date

    I'm sorry, I misread the lack of the Balance column. Right now, you´re using a triangular join which can be slower than a well written cursor. There's a technique called...

    July 26, 2015 at 8:39 pm

    #1815028

  • RE: Finding the first credit balance date

    pietlinden (7/26/2015)

    I left the balance part out because it's (sort of) a derived column. You could use a windowing function to do a running total to get it. ...

    July 26, 2015 at 6:51 pm

    #1815026

  • RE: Finding the first credit balance date

    Window functions are available in 2005, I'm not sure why do you say they're not.

    You missed the most important column in the sample data that you posted (and you included...

    July 26, 2015 at 6:41 pm

    #1815024

  • RE: Finding the first credit balance date

    Sure, it can be done. Could you please post DDL and INSERT statements for your sample data?

    Check the following article or the one in my signature to understand how to...

    July 26, 2015 at 2:10 pm

    #1815018

Viewing 15 posts - 4,576 through 4,590 (of 8,731 total)