Forum Replies Created

Viewing 15 posts - 826 through 840 (of 8,731 total)

  • RE: Force execution plan in a view

    Jeff Moden - Tuesday, November 21, 2017 9:10 PM

    Hmmm... I haven't tried it but perhaps a BIGINT Sequence would work here.

    This might...

    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

    November 22, 2017 at 7:41 am

    #1969172

  • RE: Force execution plan in a view

    sgmunson - Tuesday, November 21, 2017 10:30 AM

    How about replacing the view with an inline table-valued function?  You might still need...

    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

    November 21, 2017 at 11:08 am

    #1969063

  • RE: Cumulative subtraction

    The solutions are really nice, but I just want to add something to the mix. This is a simple approach, but should be handled with care (with great power comes...

    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

    November 21, 2017 at 10:52 am

    #1969055

  • RE: Force execution plan in a view

    GilaMonster - Monday, November 20, 2017 9:14 AM

    Not queries. Just that one that has the problem.

    That one is repeated in multiple places...

    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

    November 20, 2017 at 9:18 am

    #1968804

  • RE: Force execution plan in a view

    GilaMonster - Monday, November 20, 2017 8:26 AM

    Luis Cazares - Monday, November 20, 2017 7:46 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

    November 20, 2017 at 9:12 am

    #1968801

  • RE: Force execution plan in a view

    Alan.B - Monday, November 20, 2017 8:03 AM

    Plan guides are available in 2005+.

    Great! I'll have to learn something new today.

    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

    November 20, 2017 at 8:09 am

    #1968776

  • RE: Force execution plan in a view

    GilaMonster - Monday, November 20, 2017 7:30 AM

    Plan guide for the query, if you want to use a hint. Otherwise, make sure...

    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

    November 20, 2017 at 7:46 am

    #1968767

  • RE: Help with aggregate function

    Lengthy, but there might not be a better alternative without fixing the data.

    CREATE TABLE SampleData(
      col1 varchar(10),
      col2 varchar(10),
      col3 int
    );
    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

    November 17, 2017 at 2:11 pm

    #1968604

  • RE: How to make distinct when column is not in the view

    craig.jenkins - Friday, November 17, 2017 8:24 AM

    Thanks for the help but still getting duplicates.  Appreciate it tho

    What do you mean by...

    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

    November 17, 2017 at 11:35 am

    #1968584

  • RE: How to make distinct when column is not in the view

    craig.jenkins - Friday, November 17, 2017 6:36 AM

    Guys, is there a way for me to show the results of the below where...

    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

    November 17, 2017 at 7:04 am

    #1968511

  • RE: Add only changed or new rows to table

    DonkeyKing - Thursday, November 16, 2017 10:02 AM

    Hi I am a DBA who does a small bit of SSIS / TSQL development...

    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

    November 16, 2017 at 10:07 am

    #1968399

  • RE: Trying to convert a int @variable to a varchar @variable with leading zero.

    And here's a small improvement.

    DECLARE @Number as int = 0
    DECLARE @varnumber as varchar(2)

    WHILE @Number < = 79
    BEGIN
    SET @Number = @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

    November 16, 2017 at 6:53 am

    #1968337

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki - Wednesday, November 15, 2017 1:25 PM

    They say it is scalability and rapid development.
    I believe it is because someone heard...

    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

    November 15, 2017 at 2:15 pm

    #1968279

  • RE: Should this index be clustered?

    ChrisM@Work - Wednesday, November 15, 2017 7:01 AM

    Here's a reminder of the issues you may experience if you're performing deletes from your...

    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

    November 15, 2017 at 7:41 am

    #1968188

  • RE: Should this index be clustered?

    Lynn Pettis - Tuesday, November 14, 2017 4:39 PM

    Alan.B - Tuesday, November 14, 2017 4:36 PM

    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

    November 15, 2017 at 6:22 am

    #1968170

Viewing 15 posts - 826 through 840 (of 8,731 total)