Forum Replies Created

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

  • RE: Extracting Numbers from String

    Just another way to approach this... If you know what characters you want to remove you can use this translate function. Note the comments for how to use.

    IF...

    "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 7:42 pm

    #1802480

  • RE: Alternavite to RDP on Prod server

    Yep. RDP is very bad for managing SQL Server. For stuff like services, event viewer, etc you can right-click on those things locally and and select "manage another computer"...

    "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 4:50 pm

    #1802475

  • RE: Extracting Numbers from String

    Eirikur Eiriksson (6/2/2015)

    Lowell (6/2/2015)

    Eirikur Eiriksson (6/2/2015)

    Lowell (6/2/2015)

    take a look at this thread from a while ago: it's got some excellent examples on stripping out non-numeric characters in the fastest way...

    "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:51 pm

    #1802468

  • RE: SSRS Report Permission

    sheba.sql (6/2/2015)

    Hello all,

    I gave a user all required permission to view the SSRS report. User is able to select from the dropdown list but unable to view the data, It...

    "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:35 pm

    #1802467

  • 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

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