Forum Replies Created

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

  • 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

  • RE: When someone asks you what you do for work, how do you answer?

    Unless it's someone in my field I say "computer stuff". Anything beyond that I generally get a blank stare.

    "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

    July 30, 2018 at 12:41 pm

    #1999556

  • RE: The GDPR is Coming to the US

    Jason A. Long - Monday, July 9, 2018 11:26 AM

    How about, "Nothing is free. If you aren't paying for it, you're...

    "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

    July 17, 2018 at 1:52 pm

    #1997904

  • RE: Joining on the numeric part of string...

    pietlinden beat me to it - here's what that solution would look like:

    -- Sample data
    USE tempdb
    GO
    IF OBJECT_ID('dbo.t1') IS NOT NULL DROP TABLE dbo.t1;

    "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

    July 11, 2018 at 3:40 pm

    #1997231

  • RE: Get first date and last date of the current month base on Work Week

    I'm stuck on the last Sunday at the moment but here's how you handle the first Monday. 
    Lynn Pettis has a great post about common date routines.  I...

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

    #1994759

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