Forum Replies Created

Viewing 15 posts - 1,411 through 1,425 (of 2,458 total)

  • RE: A Case FOR Cursors...

    Andy DBA (6/2/2015)

    fundpc (6/2/2015)

    ...and yes I am old enough to have been there when our IBM RD281 disk pack, read heads driven with hydraulic rams, blew a packing 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

    June 2, 2015 at 3:25 pm

    #1802466

  • RE: A Case FOR Cursors...

    Hugo Kornelis (6/2/2015)

    Alan.B (6/1/2015)

    Until someone, anyone, can post an example where a cursor or other iterative method was faster than a well-written set-based solution I will remain convinced that the...

    "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

    June 2, 2015 at 3:10 pm

    #1802464

  • RE: Primary Key and Identity Column's

    Sean Lange (6/2/2015)

    Alan.B (6/1/2015)

    patelxx (6/1/2015)

    Hi Phil,

    Why do I need the word Clustered at the end? I've never seen this before.

    cheers

    You don't.

    When you create a primary key you have...

    "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

    June 2, 2015 at 11:54 am

    #1802384

  • RE: Trying to learn SQL - Advice

    fliteskates (6/1/2015)

    Eric M Russell (6/1/2015)

    fliteskates (5/29/2015)

    Hey all,

    I am trying to learn how to use SQL and I have downloaded MSSQL Server 2014 Express. I am a complete beginner with little...

    "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

    June 2, 2015 at 11:30 am

    #1802377

  • RE: A Case FOR Cursors...

    Brian J. Parker (6/1/2015)

    Alan.B (6/1/2015)

    So here's what's the takeaway here? It's better for an update to run for several extra seconds to prevent a several hundred ms blip for 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

    June 1, 2015 at 9:23 pm

    #1802211

  • RE: A Case FOR Cursors...

    Brian J. Parker (6/1/2015)

    g.britton (6/1/2015)

    Actually, I challenge that claim. Please post some actual results.

    Alan.B (6/1/2015)

    Until someone, anyone, can post an example where a cursor or other iterative method was...

    "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

    June 1, 2015 at 6:04 pm

    #1802189

  • RE: Primary Key and Identity Column's

    patelxx (6/1/2015)

    Hi Phil,

    Why do I need the word Clustered at the end? I've never seen this before.

    cheers

    You don't.

    When you create a primary key you have the ability to...

    "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

    June 1, 2015 at 4:24 pm

    #1802176

  • RE: A Case FOR Cursors...

    ericksrm (6/1/2015)

    Alan.B (6/1/2015)

    Amen. It always comes down to performance.

    Alan, totally agree with you that "it always comes down to performance". I threw together a quick and dirty example to...

    "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

    June 1, 2015 at 1:50 pm

    #1802153

  • RE: A Case FOR Cursors...

    Brian J. Parker (6/1/2015)

    g.britton (6/1/2015)

    Actually, I challenge that claim. Please post some actual results.

    Alan.B (6/1/2015)

    Until someone, anyone, can post an example where a cursor or other iterative method was...

    "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

    June 1, 2015 at 1:35 pm

    #1802147

  • RE: A Case FOR Cursors...

    Emph. mine.

    Sioban Krzywicki (6/1/2015)

    Is maintaining a complex SQL query more difficult than maintaining a cursor? Sometimes, but in the end, performance is king. The code isn't there to make...

    "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

    June 1, 2015 at 11:15 am

    #1802091

  • RE: A Case FOR Cursors...

    Bill Talada (6/1/2015)

    ...

    SET Solution:

    ...

    Possibly very high disk, memory, log usage.

    Relative to what? Do you have any examples of a specific problem where a cursor, loop or recursive CTE generates less...

    "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

    June 1, 2015 at 10:19 am

    #1802064

  • RE: A Case FOR Cursors...

    I fall into the "avoid row-by-row operations" camp. Around here that's commonly referred to as RBAR. Itzek Ben-Gan, an well respected author an authority on T-SQL warns against iterative approaches...

    "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

    June 1, 2015 at 8:24 am

    #1802007

  • RE: Trying to learn SQL - Advice

    fliteskates (5/29/2015)

    Hey all,

    I am trying to learn how to use SQL and I have downloaded MSSQL Server 2014 Express. I am a complete beginner with little experience.

    I just downloaded 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

    May 30, 2015 at 12:35 am

    #1801796

  • RE: MCSE Data Platform 2012 and salary

    No certs, happy with salary. I don't think not having them has hurt me in any way. If you are new and trying to get your foot in the door...

    "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

    May 30, 2015 at 12:28 am

    #1801795

  • RE: Are the posted questions getting worse?

    Luis Cazares (5/29/2015)

    I'm not sure if you've seen this, but it made me laugh and wanted to share it with you.

    http://geekandpoke.typepad.com/geekandpoke/2011/01/nosql.html

    Haha. Would be even funnier if it weren't so true....

    "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

    May 29, 2015 at 10:31 am

    #1801654

Viewing 15 posts - 1,411 through 1,425 (of 2,458 total)