Forum Replies Created

Viewing 15 posts - 346 through 360 (of 8,731 total)

  • RE: Max Degree of Parallelism

    Some other sources:
     https://www.brentozar.com/archive/2013/09/five-sql-server-settings-to-change/
     https://www.mssqltips.com/sqlservertip/2650/what-maxdop-setting-should-be-used-for-sql-server/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 9, 2018 at 9:42 am

    #2001065

  • RE: Max Degree of Parallelism

    Here's the recommendation from Microsoft
    https://support.microsoft.com/en-us/help/2806535/recommendations-and-guidelines-for-the-max-degree-of-parallelism-confi

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 9, 2018 at 9:39 am

    #2001064

  • RE: Eval function TSql

    marco.bugada - Thursday, August 9, 2018 9:05 AM

    right, but it's not enough for me. the posted example was too simple. I...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 9, 2018 at 9:11 am

    #2001053

  • RE: Are the posted questions getting worse?

    Is this about something new that I missed? Something old that I've never heard about? Or just someone bringing terms from other products?
    https://www.sqlservercentral.com/Forums/1984213/index-join-and-index-intersection

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 9, 2018 at 9:06 am

    #2001050

  • RE: Converting decimals to HH:MM:SS

    david_h_edmonds - Thursday, August 9, 2018 7:50 AM

    drew.allen - Thursday, August 9, 2018 7:29 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 9, 2018 at 8:47 am

    #2001039

  • RE: index join and index intersection

    arvind.patil 60171 - Thursday, August 9, 2018 3:09 AM

    Can anybody tell me the difference b/w index join and index intersection.

    Is that from...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 9, 2018 at 6:24 am

    #2000995

  • RE: Help required with GROUP BY

    faulknerwilliam2 - Thursday, August 9, 2018 5:42 AM

    Hello

    I have 4 work trays and I would like a report that gives me the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 9, 2018 at 6:21 am

    #2000994

  • RE: how do i display only the 6 character from the right in ssrs

    Just for fun, a different option.
    =Mid(<string>, Len(<string>) - 5, 1)
    Are you sure that you'll always have at least 6 characters in your string? What happens if  that...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 8, 2018 at 1:19 pm

    #2000901

  • RE: DATEPART WEEK start Monday

    By the way, what would happen in dates like 2018-08-29? Would you have no rows for month?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 8, 2018 at 12:44 pm

    #2000893

  • RE: DATEPART WEEK start Monday

    lanky_doodle - Wednesday, August 8, 2018 11:01 AM

    That's the ticket, thanks so much 🙂

    Can you break down the calculation for me. I...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 8, 2018 at 12:35 pm

    #2000890

  • RE: DATEPART WEEK start Monday

    lanky_doodle - Wednesday, August 8, 2018 9:53 AM

    Thanks for the tips.

    With Luis' one, that will take the next 7 days. By "this...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 8, 2018 at 10:07 am

    #2000869

  • RE: formatting T-SQL

    You should add a step for a review before pushing changes to the branch that will be deployed or as an approval just like the one you have...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 8, 2018 at 9:56 am

    #2000864

  • RE: Error: Invalid Custom SQL query.

    You shouldn't be focusing on the warning. That's not causing the error.
    The error might be caused by some statement with a functionality not supported by a client. It could...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 8, 2018 at 9:15 am

    #2000846

  • RE: Huge number of tables

    JackCarrington - Wednesday, August 8, 2018 7:39 AM

    Hi all,

    I've inherited a situation where we have a business critical system with gigantic number...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 8, 2018 at 9:11 am

    #2000843

  • RE: Execute same SELECT with a different condition

    What about simplifying everything?
    I'm assuming that you don't actually need 6 columns and you only need 5 as one would be repeated.

    SELECT
      CT.claim_type_name...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 8, 2018 at 9:06 am

    #2000837

Viewing 15 posts - 346 through 360 (of 8,731 total)