Forum Replies Created

Viewing 15 posts - 7,501 through 7,515 (of 8,731 total)

  • RE: Looping through select statement

    Complete story at http://www.sqlservercentral.com/Forums/Topic1510608-392-1.aspx

    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 4, 2013 at 8:13 am

    #1663841

  • RE: Pivot, Unpivot and Cross Apply !!!! Nothing seems to work

    In this article, you can find how to do it dynamic. But I still recommend to do all this formatting outside of SQL server.

    http://www.sqlservercentral.com/articles/Crosstab/65048/

    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 4, 2013 at 8:12 am

    #1663840

  • RE: recovery model simple

    It might not be normal, but it's completely possible. Some process might have needed that the transaction log grew up to 30GB and if it's a normal process, you shouldn't...

    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 1, 2013 at 5:45 pm

    #1663620

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (11/1/2013)

    [font="Wingdings"]Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn.[/font]

    Aren't you getting too far with 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

    November 1, 2013 at 1:03 pm

    #1663574

  • RE: udf very slow?

    Alan.B (11/1/2013)

    Looks like we have been reading the same articles 😉

    More like he wrote the article you read 😛

    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 1, 2013 at 12:19 pm

    #1663560

  • RE: why is The following LineString instances are not valid.

    @g1 is overlapping itself as it's going from 2 4 to 3 4 twice.

    @g2 does not have at least two distinct points. It's a single point referenced twice.

    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 1, 2013 at 11:09 am

    #1663528

  • RE: Are the posted questions getting worse?

    Sean Lange (11/1/2013)

    SQLRNNR (11/1/2013)

    The Dixie Flatline (11/1/2013)

    Stefan Krzywicki (11/1/2013)

    SQLRNNR (11/1/2013)

    The Dixie Flatline (11/1/2013)

    SQLRNNR (11/1/2013)

    The Dixie Flatline (11/1/2013)

    SQLRNNR (11/1/2013)

    The Dixie Flatline (11/1/2013)

    [font="Wingdings"]It should be the last font on the dropdown, Luis.[/font]

    [font="Wingdings"]How...

    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 1, 2013 at 10:50 am

    #1663524

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (11/1/2013)

    Luis Cazares (11/1/2013)

    The Dixie Flatline (11/1/2013)

    SQLRNNR (11/1/2013)

    The Dixie Flatline (11/1/2013)

    SQLRNNR (11/1/2013)

    The Dixie Flatline (11/1/2013)

    [font="Wingdings"]It should be the last font on the dropdown, Luis.[/font]

    [font="Wingdings"]How sure are you about...

    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 1, 2013 at 10:47 am

    #1663520

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (11/1/2013)

    SQLRNNR (11/1/2013)

    The Dixie Flatline (11/1/2013)

    SQLRNNR (11/1/2013)

    The Dixie Flatline (11/1/2013)

    [font="Wingdings"]It should be the last font on the dropdown, Luis.[/font]

    [font="Wingdings"]How sure are you about that?[/font]

    [font="Wingdings"]Pretty sure, I don't think...

    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 1, 2013 at 10:31 am

    #1663509

  • RE: loop to set based (what am i doing wrong)

    For more information, I suggest you some more articles:

    http://www.sqlservercentral.com/Authors/Articles/Jeff_Moden/80567/

    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 1, 2013 at 10:02 am

    #1663483

  • RE: Are the posted questions getting worse?

    Am I the only one that can't change the font on SSMS to Wingdings or something similar?

    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 1, 2013 at 9:58 am

    #1663479

  • RE: Pivot, Unpivot and Cross Apply !!!! Nothing seems to work

    I'm not sure why are you doing this on SQL Server, it might be better on the front-end.

    However, if you really need to format your output like this on SQL...

    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 1, 2013 at 9:49 am

    #1663473

  • RE: loop to set based (what am i doing wrong)

    I'm not sure why would you want to do a CROSS JOIN. It will duplicate rows and might give you unexpected results. If you're updating a column with a constant,...

    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 1, 2013 at 9:30 am

    #1663458

  • RE: udf very slow?

    The lack of parallelism is just a part of the reasons why udfs slow down the code performance. I'll be glad to help (and I'm sure others will be as...

    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

    October 31, 2013 at 4:19 pm

    #1663290

  • RE: Undo the cross tab

    Gabe T. (10/31/2013)

    I should point out that #NewThings is itself not normalized (Metric1 and Metric2 should really be distinct rows in a separate table).

    Not necessarily if those 2 metrics...

    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

    October 31, 2013 at 4:16 pm

    #1663289

Viewing 15 posts - 7,501 through 7,515 (of 8,731 total)