Forum Replies Created

Viewing 15 posts - 961 through 975 (of 2,458 total)

  • RE: Are the posted questions getting worse?

    Ed Wagner (2/27/2016)

    Sean Lange (2/26/2016)

    Alan.B (2/26/2016)

    Sean Lange (2/26/2016)

    Lynn Pettis (2/26/2016)

    Alan.B (2/26/2016)

    Lynn Pettis (2/26/2016)

    I know this should go elsewhere but I feel that I'll get more responses here.

    Why do organizations believe...

    "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 29, 2016 at 9:29 am

    #1861846

  • RE: The Dangers of Algorithms

    Great article Steve. Nothing to add with respect to the algorithm discussion...

    Many of us realize that subtle changes in application code can cause issues for data, which is part of...

    "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 29, 2016 at 8:56 am

    #1861837

  • RE: The Dangers of Algorithms

    Jeff Moden (2/27/2016)

    Outstanding article, Steve. I'd discuss it a bit more but, being a customer/consumer of software, I would tick off the whole world with my thoughts in this...

    "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 29, 2016 at 8:35 am

    #1861821

  • RE: Are the posted questions getting worse?

    Sean Lange (2/26/2016)

    Lynn Pettis (2/26/2016)

    Alan.B (2/26/2016)

    Lynn Pettis (2/26/2016)

    I know this should go elsewhere but I feel that I'll get more responses here.

    Why do organizations believe that they will get more...

    "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 26, 2016 at 2:48 pm

    #1861575

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/26/2016)

    Alan.B (2/26/2016)

    Lynn Pettis (2/26/2016)

    I know this should go elsewhere but I feel that I'll get more responses here.

    Why do organizations believe that they will get more candidates for...

    "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 26, 2016 at 2:38 pm

    #1861572

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/26/2016)

    I know this should go elsewhere but I feel that I'll get more responses here.

    Why do organizations believe that they will get more candidates for a position 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

    February 26, 2016 at 1:49 pm

    #1861557

  • RE: Are the posted questions getting worse?

    djj (2/25/2016)

    Spent a couple hours rewriting a query that was taking 4 hours. Got it down to 8 minutes! Then the light bulb goes off and I realize...

    "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 25, 2016 at 2:12 pm

    #1861252

  • RE: Odd (to me) Behavior with NTILE() and NULL Values in Source Data

    EdgeOfKnowWare (2/25/2016)

    +1

    Cracked me up!

    "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 25, 2016 at 11:48 am

    #1861201

  • RE: Odd (to me) Behavior with NTILE() and NULL Values in Source Data

    Ok, here we go. This may be a bit much to follow but the key take away is that I'm showing you an excellent alternative to NTILE using a tally...

    "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 25, 2016 at 9:32 am

    #1861144

  • RE: Procedure vs Scalar function

    If you can get away with using a stored procedure then that's the way to go. Scalar UDFs are almost always poor performers and should be avoided at all costs.

    "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 25, 2016 at 5:56 am

    #1861011

  • RE: Odd (to me) Behavior with NTILE() and NULL Values in Source Data

    Just a quick update:

    I have a good solution that I'm still testing (note my earlier comment). It has taken me longer than expected. I'll try to post it in 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

    February 24, 2016 at 10:20 pm

    #1860959

  • RE: Odd (to me) Behavior with NTILE() and NULL Values in Source Data

    EdgeOfKnowWare (2/23/2016)

    Rich Mechaber (2/23/2016)

    Hi, Alan, o/p here, and I've enjoyed the follow-on conversation I started.

    This aspect of NTILE() is an eye-opening piece of information, thank you for posting...

    "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 23, 2016 at 12:26 pm

    #1860532

  • RE: Are the posted questions getting worse?

    I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then came...

    "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 23, 2016 at 12:09 pm

    #1860526

  • RE: Odd (to me) Behavior with NTILE() and NULL Values in Source Data

    So, to dig even further...

    SSC is the right place 😉

    If your table had 92 million records, and you had 9 different "Val" columns, would you still use the same 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

    February 23, 2016 at 9:59 am

    #1860481

  • RE: xml column from table

    Note my code and comments.

    USE tempdb

    GO

    -- Create a table with an XML column

    IF OBJECT_ID('tempdb.dbo.YourTable') IS NOT NULL DROP TABLE dbo.YourTable;

    CREATE TABLE dbo.YourTable(SomeID int identity primary key, SomeXML xml NOT...

    "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 23, 2016 at 8:36 am

    #1860434

Viewing 15 posts - 961 through 975 (of 2,458 total)