Forum Replies Created

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

  • RE: constant high memory usage on SQL Server 2012 SP3

    If you go into SSMS, Server/Instance properties that's where you can set the minimum and maximum memory settings. If the minimum memory setting is ~89% of your memory that would...

    "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 1, 2016 at 5:36 pm

    #1862243

  • RE: How to call a function with multiple parameters in a select statement

    Stix83 (3/1/2016)

    select statement:

    select a.Owner_Id,

    b.Name as KPI,

    B.Record_Type,

    B.Resource_Id,

    C.Display_Name,

    count(A.Owner_Id) as Max

    from amgr_appointments A

    right outer join AMGR_Resources B on A.Owner_Id = b.Resource_Id

    right outer JOIN ADMN_User_Details AS C ON A.Creator_Id=C.User_Id

    where b.Resource_Id in ('R25B2864CB6', 'R2691D72523', 'R25B2868972','R25B2868EE0','R39D1B39765',...

    "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 1, 2016 at 12:00 pm

    #1862184

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/1/2016)

    As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of 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 1, 2016 at 11:46 am

    #1862180

  • RE: MTD Default Parameters

    I don't get what MTD is or exactly what you are trying to do.

    If you are looking for a default parameter value of the first day of the month 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

    March 1, 2016 at 10:18 am

    #1862150

  • 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

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