Forum Replies Created

Viewing 15 posts - 6,211 through 6,225 (of 8,731 total)

  • RE: Derived tables vs Normal table joins

    wilks (7/1/2014)

    I would always argue in favour of the first method if only in terms or readability and assumed there couldn't be much difference, however, when checking the stats, 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

    July 1, 2014 at 10:07 am

    #1726253

  • RE: Kill SPID (SQL Spackle)

    Kenneth.Fisher (7/1/2014)

    Yes if you use KILL to end a transaction it will be rolled back and any changes made by that transaction will no longer exist. Unfortunately sometimes there...

    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

    July 1, 2014 at 9:50 am

    #1726244

  • RE: Can't see cube in Excel?

    If the cube is unprocessed, you can't see it in Excel or browse it in any other client application.

    If it fails to process, it will remain unprocessed. If it completes...

    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

    July 1, 2014 at 8:38 am

    #1726222

  • RE: Extract only numbers from a string

    Going further even if I don't like to give the complete solution. You could show some effort on trying the solutions and recommendations.

    Using Sean's sample data:

    SELECT SomeID,

    ...

    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

    July 1, 2014 at 8:24 am

    #1726213

  • RE: How do you describe what you do?

    Stuart Davies (7/1/2014)

    "But. . . . but . . but you work in IT don't you??"

    :rolleyes:

    A friend of mine was asked to check the lamp from 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

    July 1, 2014 at 8:11 am

    #1726209

  • RE: And then today this happened...

    Am I missing something in here?

    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 30, 2014 at 12:41 pm

    #1725955

  • RE: rewrite join

    ramrajan (6/30/2014)

    the objective is to replace the NOT in with some joins

    What are you expecting to get from this? It might affect performance and the result should be the same...

    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 30, 2014 at 8:37 am

    #1725884

  • RE: Extract only numbers from a string

    What happens when you have more than 2 numbers?

    You could use the Pattern Split explained on this article: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

    Declare @X varchar(100)

    Select @X= 'Here is some text 15234 here is some...

    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 30, 2014 at 8:23 am

    #1725874

  • RE: Why Primary Keys can be important on large tables

    Basically, the article is describing the need for clustered indexes and not precisely the need of Primary Keys.

    PKs are used for referential integrity and are part of the logical design.

    CI...

    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 30, 2014 at 7:52 am

    #1725861

  • RE: Are the posted questions getting worse?

    Congratulations Koen. You're certainly one of the top posters on Bi.

    On a completely different subject, I'm taking 20467BC course this week and found some surprises like using while loops...

    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 24, 2014 at 10:08 am

    #1724393

  • RE: Optimizing ORDER BY query

    Is that id an identity column? Could you remove the identity property to be able to update it with a ROW_NUMBER() by the natural key? Or simply use the ROW_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

    June 22, 2014 at 12:07 pm

    #1723861

  • RE: Optimizing ORDER BY query

    ORDER BY doesn't seems logical on an ETL process. Why would you need it?

    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, 2014 at 11:20 am

    #1723858

  • RE: Input paramter for Store Procedure like in statement 'Value1','Value2'

    Thak you for the feedback.;-)

    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, 2014 at 10:23 am

    #1723855

  • RE: Why work this Code without Error?

    Agreed, you don't need a cursor but you might not even need a udf. If you share the code, we might be able to help you to speed this query....

    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, 2014 at 10:05 am

    #1723851

  • RE: Home Page

    I've found the same problem since the site was migrated. I hope everything comes back to normal soon.

    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, 2014 at 10:04 am

    #1723850

Viewing 15 posts - 6,211 through 6,225 (of 8,731 total)