Forum Replies Created

Viewing 15 posts - 376 through 390 (of 2,458 total)

  • RE: Talking baseball

    Removed (posted twice somehow)

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 4, 2016 at 3:07 pm

    #1910738

  • RE: Talking baseball

    We dyed the Chicago River Cubs blue.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 4, 2016 at 3:07 pm

    #1910737

  • RE: Split Record by Field into Multiple Records

    Another way (building off Drew and Kevin's excellent solutions) would be like this:

    WITH iTally(n) AS

    (

    SELECT n

    FROM ( VALUES(1), (2), (3), (4), (5), (6), (7), (8),...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 4, 2016 at 10:45 am

    #1910657

  • RE: SSIS Package documentor

    I missed the article the first time around but just read it.

    The fact that SSIS packages are XML files makes documenting SSIS so much easier provided you have a...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 4, 2016 at 9:27 am

    #1910634

  • RE: Help on Hierarchy Query

    Luis Cazares (11/2/2016)

    Why do you even need a derived table?

    SELECT

    meetingID,

    ProviderName,

    SubGroupName,

    SessionName,

    ...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 2, 2016 at 1:32 pm

    #1910221

  • RE: WITH INDEX hint

    I use query hints from time-to-time (not too often) but only when there is no doubt that it's the right choice. The conventional wisdom seems to be that, if you...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 2, 2016 at 1:24 pm

    #1910220

  • RE: Help on Hierarchy Query

    thomashohner (11/2/2016)

    I think i figured it out. Ugly SQL but it seems to work.

    Thanks

    --Meeting, Subgroup, Session

    CREATE TABLE #Table (MeetingID INT , Levels VARCHAR(20), ProviderName VARCHAR(20), PatientName VARCHAR(20), SubGroupName VARCHAR(20),SessionName...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 2, 2016 at 12:55 pm

    #1910210

  • RE: Talking baseball

    jasona.work (11/2/2016)

    So, any bets on how much of Chicago will be left standing after tonight, if the Cubs win (or lose?)

    I'm thinking something along the lines of when the Detroit...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 2, 2016 at 11:38 am

    #1910190

  • RE: Easy way to search for a string any where within XML column?

    This is an interesting 5-year old thread...

    Something interesting to note is that the default output for the SQLXML value method is all child text. With that in mind, this...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 2, 2016 at 10:39 am

    #1910172

  • RE: Talking baseball

    Markus (11/2/2016)

    This last game could go either way... I was looking this morning and both teams have scored 19 runs each in these 6 games.

    Kluber is their best...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 2, 2016 at 8:18 am

    #1910113

  • RE: Today's Random Word!

    djj (11/1/2016)

    Luis Cazares (11/1/2016)

    Ray K (11/1/2016)

    Resistance

    Rebellion

    Jedi

    academy

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 1, 2016 at 10:59 am

    #1909953

  • RE: Performance issues when BLOB-shredding....

    mickegohle (11/1/2016)

    Hi all,

    I have tried to get an insert query to execute faster.

    I have a table with an xml-column in it. This xml is quite big and there are...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 1, 2016 at 9:28 am

    #1909907

  • RE: SQL Server equivalent for MySQL's Substring_index

    Here's kind of a hybrid of both of Luis' solutions:

    let's say you have a maximum number of delimiters, for my example we'll say a max of 6 (but you...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 31, 2016 at 2:28 pm

    #1909748

  • RE: Talking baseball

    djj (10/24/2016)

    Alan.B (10/22/2016)

    Alan.B (10/14/2016)

    Ray K (10/14/2016)

    Tried to stay up last night to watch Dodgers vs. Nationals Game 5. I made it to the 8th inning before I finally gave...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 31, 2016 at 8:28 am

    #1909645

  • RE: Talking baseball

    Alan.B (10/14/2016)

    Ray K (10/14/2016)

    Tried to stay up last night to watch Dodgers vs. Nationals Game 5. I made it to the 8th inning before I finally gave up and...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 22, 2016 at 8:56 pm

    #1908197

Viewing 15 posts - 376 through 390 (of 2,458 total)