Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 8,731 total)

  • RE: SUBSTRING and CHARINDEX query.... please help.

    Eirikur Eiriksson - Friday, June 23, 2017 7:43 AM

    If you are on SQL Server 2016 then use the new native

    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

    June 23, 2017 at 7:56 am

    #1947958

  • RE: Slow performance of SP

    You need to share more information if you want actual help. You could also anonymize the plan before sharing it. SQL Sentry has that option.
    How to Post...

    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

    June 23, 2017 at 7:44 am

    #1947955

  • RE: SUBSTRING and CHARINDEX query.... please help.

    Decomposing the splitter function might not give the best performance, but it could help in your case.

    --Create sample data
    CREATE TABLE #Sample ( SomeColumn varchar(1000))
    INSERT...

    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

    June 22, 2017 at 10:52 am

    #1947810

  • RE: Alternative to Group by and Having

    John Mitchell-245523 - Thursday, June 22, 2017 7:33 AM

    Something like this, maybe.  Although I'm a bit puzzled how there are two base...

    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

    June 22, 2017 at 7:55 am

    #1947762

  • RE: Are the posted questions getting worse?

    Ed Wagner - Wednesday, June 21, 2017 1:51 PM

    Did your wife get to join you yet?

    Yes, she's been with me for...

    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

    June 22, 2017 at 7:50 am

    #1947761

  • RE: While loop

    Something like this might work. If I understand correctly.

    DECLARE --Parameters?
       @IRN nvarchar(254),
       @DocTitle nvarchar(254),
       @Directory nvarchar(254);

    DECLARE @DocName nvarchar(254)...

    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

    June 22, 2017 at 6:59 am

    #1947735

  • RE: Alternative to Group by and Having

    Sangeeth878787 - Thursday, June 22, 2017 5:35 AM

    GilaMonster - Thursday, June 22, 2017 4:48 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

    June 22, 2017 at 6:28 am

    #1947727

  • RE: Are the posted questions getting worse?

    Ed Wagner - Wednesday, June 21, 2017 11:45 AM

    Well, congratulations Luis.  Well done.  Are you still in Atlanta?  Just as importantly,...

    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

    June 21, 2017 at 1:38 pm

    #1947628

  • RE: Are the posted questions getting worse?

    Sean Lange - Wednesday, June 21, 2017 9:42 AM

    This is totally off topic but man I really hate contract developers sometimes.

    Good...

    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

    June 21, 2017 at 10:32 am

    #1947600

  • RE: Alternative to Group by and Having

    This is an alternative. It may or may not improve the query (it would definitively not improvise it 🙂 )

    With CTE as
    (
      Select sd.*,...

    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

    June 21, 2017 at 8:24 am

    #1947568

  • RE: Performance: TRUNCATE vs. DROP/CREATE

    Did you check for any blocking happening while testing?

    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

    June 21, 2017 at 7:07 am

    #1947549

  • RE: Translating True or False into another language

    I remember that AdventureWorks has an example on how to do this in SSAS. I don't have it installed right now, but you should check it.
    Here's an article 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

    June 21, 2017 at 6:12 am

    #1947535

  • RE: SQL: HOW to concatenate two fields using trigger,

    You still didn't post the code that you're using.
    That's a horrible design and a bad idea. It reminds me of a db horror story that you can check in...

    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

    June 21, 2017 at 6:08 am

    #1947533

  • RE: Are the posted questions getting worse?

    Ed Wagner - Tuesday, June 20, 2017 12:45 PM

    GilaMonster - Tuesday, June 20, 2017 10:40 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

    June 20, 2017 at 1:00 pm

    #1947452

  • RE: SQL: HOW to concatenate two fields using trigger,

    Joe Torre - Tuesday, June 20, 2017 9:37 AM

    You can use WinRar

    I'd rather use 7-zip, but that's...

    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

    June 20, 2017 at 9:45 am

    #1947405

Viewing 15 posts - 1,171 through 1,185 (of 8,731 total)