Forum Replies Created

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

  • RE: Inside the SQL Server Query Optimizer

    For those who have not read this book I highly suggest it. I picked up a physical copy at SQL In the City 2012 and could not put it down....

    "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 4, 2018 at 2:54 pm

    #1985562

  • RE: Inside the SQL Server Query Optimizer

    TheRedneckDBA - Friday, March 4, 2011 2:18 PM

    Anyone know when this will be officially published?

    In 2010 I think.

    "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 4, 2018 at 2:50 pm

    #1985561

  • RE: ETL or ELT

    RonKyle - Wednesday, April 4, 2018 5:34 AM

    It is not uncommon that the culprit is poorly designed transformation inside the ETL...

    "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 4, 2018 at 12:22 pm

    #1985534

  • RE: Columns Order in XML output of SSRS report

    i have a [tables] which contains ssn, city, state, zip columns after i run this report and save as xml 
    then reopen it shows columns order as xip, state, city,...

    "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 4, 2018 at 10:47 am

    #1985503

  • 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

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