Forum Replies Created

Viewing 15 posts - 1,936 through 1,950 (of 2,462 total)

  • RE: do you have a StripNonNumeric ITVF function?

    Gents

    First: Dang it Sean - you beet me to it! I had a very similar solution but you posted yours first. That said, I did do a performance test 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 25, 2014 at 11:23 am

    #1724735

  • RE: returning only portion of string

    Eugene Elutin (6/20/2014)

    Alan.B (6/19/2014)

    Eugene Elutin (6/19/2014)

    SUBSTRING is more standard than PARSENAME so the code would be more portable using SUBSTRING (for those people that care about that stuff :-P)

    Yep,...

    "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 20, 2014 at 9:12 am

    #1723629

  • RE: returning only portion of string

    Eugene Elutin (6/19/2014)

    SUBSTRING is more standard than PARSENAME so the code would be more portable using SUBSTRING (for those people that care about that stuff :-P)

    Yep, as long 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

    June 19, 2014 at 12:14 pm

    #1723392

  • RE: returning only portion of string

    Eugene Elutin (6/19/2014)

    May I ask please, if there is any reason to use SUBSTRING instead of PARSENAME other than love of typing and having more of pink in the code,...

    "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 19, 2014 at 10:12 am

    #1723340

  • RE: returning only portion of string

    Without using parsename:

    ;WITH sample_data(val)

    AS

    (

    SELECT '1.9999-Q1'

    UNION SELECT '01.9999-Q11'

    )

    SELECTval,

    part1 = substring(val,1,charindex('.',val)-1),

    part2 = substring(val,charindex('.',val)+1,(charindex('-',val)-charindex('.',val))-1),

    part3 = substring(val,charindex('-',val)+1,...

    "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 19, 2014 at 9:37 am

    #1723321

  • RE: How to join to a comma delimited list

    rightontarget (6/16/2014)

    Hi all,

    I have a table:

    id pallet color

    1 a red,blue

    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

    June 16, 2014 at 3:17 pm

    #1722102

  • RE: Identifying cause of poor perfomance

    This click takes less than a second in staging and about 33 seconds in production.

    A common cause of this kind of problem is when critical indexes are not moved...

    "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 16, 2014 at 10:28 am

    #1722023

  • RE: Database Size is shwoing Much larger then Actual Data

    This Database used to be in simple recovery model and I did change it to Full now. I am taking T-log backup and full backup .

    No, no... My apologies...

    "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 13, 2014 at 12:36 pm

    #1721634

  • RE: Would like some feedback on contractors as employers

    Doctor Who 2 (6/12/2014)

    Alan.B (6/11/2014)

    I am going to make a wild guess and say that you are in Albuquerque, NM or somewhere nearby? I don't know much about that market...

    "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 13, 2014 at 11:12 am

    #1721593

  • RE: Database Size is shwoing Much larger then Actual Data

    Users say a lot of things...

    A few questions to help you sort this out:

    1) Do you track your DB growth? Do you have any idea how fast this DB...

    "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 12, 2014 at 12:02 pm

    #1721195

  • RE: SQL 2008 R2 Standard vs Enterprise on Parallelism

    ...what's missing from Standard SQL edition where parallelism is concerned. I thought it was only for special index operations... are we talking about two different things?

    I just wanted to add...

    "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 11, 2014 at 3:08 pm

    #1720907

  • RE: Would like some feedback on contractors as employers

    I am going to make a wild guess and say that you are in Albuquerque, NM or somewhere nearby? I don't know much about that market but know that there...

    "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 11, 2014 at 10:52 am

    #1720831

  • RE: Converting XPath to FLWOR

    Can anyone help me build a FLOWR-based query that produces the same result as the pure XPath one?

    I don't know if that is possible. I thought I saw an article...

    "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 10, 2014 at 5:23 pm

    #1720606

  • RE: Regroupement sur interval de date

    Premièrement, je ne parle pas français. Je n'ai pas une solution complète mais cela devrait aider...

    passer à l'anglais(switching to English)...

    OK. You have the following data:

    -- données de l'échantillon

    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 9, 2014 at 3:44 pm

    #1720238

  • RE: When criteria in the where clause result is different than the same criteria in the on clause. Why?

    I think we could figure this out a little easier if you included the query plan the each query produces. Could you run this with " include actual query plan"...

    "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 8, 2014 at 7:03 am

    #1719956

Viewing 15 posts - 1,936 through 1,950 (of 2,462 total)