Forum Replies Created

Viewing 15 posts - 91 through 105 (of 2,462 total)

  • RE: Find and replace third occurrence of the string

    Just for fun I thought I'd throw in a solution that leverages NGrams8k. This will likely be a little slower than what Jason posted but it parallelizes nicely...

    "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

    October 22, 2018 at 3:19 pm

    #2010697

  • RE: Running Concatenation (like running totals)

    You can do this on SQL Server 2005+ like so:

    -- Your Data
    DECLARE @table TABLE(ColA INT, ColB CHAR(1), RowNumber INT);
    INSERT @table(ColA,ColB,RowNumber)
    SELECT ColA,ColB,RowNumber
    FROM (VALUES

    "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

    October 22, 2018 at 2:14 pm

    #2010690

  • RE: SQL Server Default Constraints can be constants, functions or objects. What kind of objects other than functions?

    gbritton1 - Thursday, October 4, 2018 7:02 AM

    Alan.B - Wednesday, October 3, 2018 3:40 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

    October 4, 2018 at 7:43 am

    #2008051

  • RE: SQL Server Default Constraints can be constants, functions or objects. What kind of objects other than functions?

    gbritton1 - Wednesday, October 3, 2018 7:28 AM

    What kind of objects may be specified, other than constants or functions?

    They worded this BOL...

    "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

    October 3, 2018 at 3:40 pm

    #2007981

  • RE: Query Performance Improvement

    Jonathan AC Roberts - Wednesday, October 3, 2018 11:06 AM

    Not sure what you're trying to do, you haven't given much information,...

    "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

    October 3, 2018 at 11:53 am

    #2007917

  • RE: Query Performance Improvement

    thenewbee - Wednesday, October 3, 2018 10:49 AM

    Hi All,
    I'm very new to PI and sorry if this is a silly question, but...

    "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

    October 3, 2018 at 11:52 am

    #2007916

  • RE: Talking baseball

    Steve Jones - SSC Editor - Wednesday, September 26, 2018 2:35 PM

    I am praying for this: https://www.mlb.com/news/how-nl-contenders-could-end-season-in-a-tie/c-295843618

    Be careful what 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

    October 1, 2018 at 6:09 am

    #2007482

  • RE: Regex in Replace?

    ken.trock - Tuesday, September 25, 2018 2:39 PM

    Phil Parkin - Tuesday, September 25, 2018 2:21 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

    September 26, 2018 at 12:25 pm

    #2007140

  • RE: Cost Threshold For Parallelism - Your opinion

    CC-597066 - Thursday, September 13, 2018 8:02 PM

    Alan.B - Tuesday, September 11, 2018 8:57 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

    September 14, 2018 at 10:31 am

    #2005806

  • RE: Best Practice Help - Table Structures

    amy26 - Friday, September 7, 2018 4:17 PM

    Hi there, I am being asked to provide a list of all the reasons that...

    "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

    September 12, 2018 at 1:03 pm

    #2005493

  • RE: Does a check constraint with UDF has performance impact on Query?

    In addition to what everyone else said -
    it's worth noting that T-SQL scalar user defined functions (UDF) are generally horrible and cause all kinds of problems even when...

    "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

    September 12, 2018 at 12:04 pm

    #2005478

  • RE: Insert data in Microsoft Word, Help

    One thing you could try (but this is a little advanced and would require a little reading) is to use an XML Transform to generate a word document. Note

    "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

    September 11, 2018 at 11:31 am

    #2005282

  • RE: Cost Threshold For Parallelism - Your opinion

    Great question - I think this is a good topic that isn't talked about enough.

    Per Books Online:

    "While the default value of 5 is retained for backwards...

    "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

    September 11, 2018 at 8:57 am

    #2005253

  • RE: ISNUMERIC function

    peter.row - Friday, September 7, 2018 8:50 AM

    Sean Lange - Friday, September 7, 2018 8:43 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

    September 11, 2018 at 7:53 am

    #2005239

  • RE: Bringing them back from the dead

    Just read through this. Very good stuff. I've unwillingly become a part-time accidental DBA at work and deal with a my share of failing SQL instances. This will be good...

    "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

    September 11, 2018 at 7:35 am

    #2005232

Viewing 15 posts - 91 through 105 (of 2,462 total)