Forum Replies Created

Viewing 15 posts - 136 through 150 (of 2,462 total)

  • RE: CREATING A 2ND TEMP TABLE BASED ON THE CONTENTS OF 1ST TEMP TABLE`

    Can you post some DDL for the tables that you are pulling data from (Note the link in my signature line for best practices on getting help)

    "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

    March 7, 2018 at 9:48 am

    #1982247

  • RE: What non-database skills should a DBA have?

    The job title of DBA means different things to different people. Luis touched on some of the core responsibilities. My first question would be: what is their job description -...

    "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

    March 7, 2018 at 9:42 am

    #1982245

  • RE: Parse a string help

    Some code formatting food for thought...
    For cases where I need to repeat the same expression multiple times you can create on "on-the-fly" inline function to simplify your code. In...

    "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

    March 7, 2018 at 9:11 am

    #1982240

  • RE: removing dups for update

    davef 22400 - Wednesday, February 28, 2018 12:44 PM

    Hmm. not sure I follow

    Sorry. Normally I would include an example but I 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

    February 28, 2018 at 1:35 pm

    #1981549

  • RE: Help me with the regular expression

    drew.allen - Wednesday, February 28, 2018 12:52 PM

    Alan.B - Wednesday, February 28, 2018 12:42 PM

    "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

    February 28, 2018 at 1:09 pm

    #1981545

  • RE: Help me with the regular expression

    ZZartin - Wednesday, February 28, 2018 12:33 PM

    Another option is to use TRY_CONVERT() if you want to make sure it'll actually convert...

    "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

    February 28, 2018 at 12:42 pm

    #1981538

  • RE: Help me with the regular expression

    WHERE @SearchVal NOT LIKE '%[^0-9.]%'
    AND LEN(@SearchVal) - LEN(REPLACE(@SearchVal,'.','')) < 2

    "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

    February 28, 2018 at 12:27 pm

    #1981532

  • RE: removing dups for update

    Alan.B - Wednesday, February 28, 2018 11:36 AM

    The solution will involve ROW_ NUMBER() OVER (PARTITION BY empnum ORDER BY email DESC, LEN(<name...

    "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

    February 28, 2018 at 11:38 am

    #1981521

  • RE: removing dups for update

    The solution will involve ROW_ NUMBER() OVER (PARTITION BY empnum ORDER BY email DESC, LEN(<name field you're measuring> DESC)

    "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

    February 28, 2018 at 11:36 am

    #1981520

  • RE: Does denormalizing the data enhance performance?

    jcelko212 32090 - Thursday, February 1, 2018 11:12 AM

    NewBornDBA2017 - Wednesday, January 31, 2018 11:00 AM
    "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

    February 1, 2018 at 12:03 pm

    #1978256

  • RE: Does denormalizing the data enhance performance?

    A few things:
    1. The plan you attached is the Estimated Plan which will not be helpful here
    2. A TOP (10) - that will affect the execution plan, what...

    "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

    January 31, 2018 at 1:27 pm

    #1978094

  • RE: Full or simple recovery for system DBs?

    It depends on how much far back you want to go. I don't think I've ever done a point-in-time restore to the any system database so, for me, simple is...

    "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

    January 29, 2018 at 12:45 pm

    #1977761

  • RE: Advice on how to transition into remote work

    Lynn Pettis - Tuesday, January 23, 2018 4:46 PM

    Alan.B - Tuesday, January 23, 2018 2:01 PM
    "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

    January 24, 2018 at 8:37 am

    #1977117

  • RE: Advice on how to transition into remote work

    I'm in Chicago, IL and can only speak about what I've seen in America. From what I'e seen, more and more companies are allowing remote work. Our DBA works from...

    "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

    January 23, 2018 at 2:01 pm

    #1976998

  • RE: Today's Random Word!

    Ray K - Thursday, January 18, 2018 1:26 PM

    ManicStar - Thursday, January 18, 2018 9:59 AM
    "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

    January 18, 2018 at 2:43 pm

    #1976426

Viewing 15 posts - 136 through 150 (of 2,462 total)