Forum Replies Created

Viewing 15 posts - 121 through 135 (of 2,458 total)

  • RE: ETL or ELT

    I'll admit that I often prefer to transform data inside of a SQL Server target, OLTP or DW database. The reason is that mass changes are often easier with...

    "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

    April 3, 2018 at 3:20 pm

    #1985385

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, March 29, 2018 2:38 PM

    Jeff Moden - Thursday, March 29, 2018 1:35 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

    April 3, 2018 at 2:09 pm

    #1985376

  • RE: The SQL Joke Thread

    What did the DBA say to the Developer?
    It doesn't matter, he wasn't listening anyway

    "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 16, 2018 at 11:23 am

    #1983617

  • RE: Today's Random Word!

    Ed Wagner - Friday, March 16, 2018 8:22 AM

    ManicStar - Friday, March 16, 2018 6:35 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

    March 16, 2018 at 8:27 am

    #1983583

  • RE: How to name the output column from an XML query

    Douglas Osborne-229812 - Wednesday, March 14, 2018 10:21 AM

    SQL XML Gods,

    Everyone - how do I execute the following query and set 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

    March 14, 2018 at 1:00 pm

    #1983276

  • RE: Replacing hidden characters

    I don't know what the issue is here but you could use ngrams8k to perform an character by character analysis like this: 

    -- sample data
    DECLARE @table table(someId int...

    "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 13, 2018 at 7:56 pm

    #1983080

  • RE: Parse a string help

    @Jeffrey Williams 3188
    Ditto what Lynn said about...

    "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 10, 2018 at 4:21 pm

    #1982709

  • RE: Parse a string help

    My apologies if I came off as rude. I was just trying to point out that what you posted was overkill for the requirement. I write must faster code than...

    "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 9, 2018 at 9:03 pm

    #1982696

  • RE: Parse a string help

    Jeffrey Williams 3188 - Friday, March 9, 2018 1:20 PM

    If the format will always be delimited by a dash - then 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

    March 9, 2018 at 5:53 pm

    #1982691

  • RE: T-SQL or Standard SQL

    icester - Wednesday, March 7, 2018 1:07 PM

    Thanks Lynn & Jeff for your input.  I too will stick with using T-SQL over...

    "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 2:06 pm

    #1982300

  • RE: Parse a string help

    Lynn Pettis - Wednesday, March 7, 2018 9:48 AM

    Alan.B - Wednesday, March 7, 2018 9:11 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

    March 7, 2018 at 9:51 am

    #1982249

  • 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

Viewing 15 posts - 121 through 135 (of 2,458 total)