Forum Replies Created

Viewing 15 posts - 106 through 120 (of 8,731 total)

  • Reply To: Tsql/SP Code Optimization

    For your question about not the comment on not helping with performance, it's because EXISTS doesn't evaluate the columns from the subquery. An interesting way to test this is 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

    September 18, 2019 at 5:18 pm

    #3681160

  • Reply To: SSC Fantasy Football 2019

    SQLDCH wrote:

    Luis Cazares wrote:

    It seems that I'll get my second victory of the season. I just hope that this one doesn't get rolled back. I'm pretty sure that Ray found a...

    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

    September 17, 2019 at 4:01 pm

    #3680755

  • Reply To: SSC Fantasy Football 2019

    It seems that I'll get my second victory of the season. I just hope that this one doesn't get rolled back. I'm pretty sure that Ray found a way to...

    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

    September 16, 2019 at 7:10 pm

    #3680465

  • Reply To: CREATE INDEX query in sys.dm_exec_requests

    webrunner wrote:

    Why is that? Does the index creation literally re-insert every row in the table into itself?

    Not exactly, but it re-inserts every row into the new index (unless it's a...

    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

    September 13, 2019 at 8:51 pm

    #3679983

  • Reply To: SSC Fantasy Football 2019

    Ray K wrote:

    Ray K wrote:

    I'm hoping for a score correction in my favor this week!

    Whoa, looks like this actually happened!!!  I just checked the site, and now it's saying I won last...

    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

    September 12, 2019 at 7:07 pm

    #3679646

  • Reply To: SSC Fantasy Football 2019

    Ray K wrote:

    Are you freakin' serious?!?!?!?!?  @#%%^&*!!!!!!

    score

    And I didn't even need the Kicker.

    I was afraid last night as Hopkins kept giving you points. But it's a nice start...

    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

    September 10, 2019 at 2:15 pm

    #3678780

  • Reply To: SSC Fantasy Football 2019

    Ray K wrote:

    So does anyone have Antonio Brown on their roster?

    That would be Lynn.

    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

    September 5, 2019 at 6:44 pm

    #3677751

  • Reply To: Are the posted questions getting worse?

    x wrote:

    drew.allen wrote:

    One of our groups is using MongoDB and we got a notice that we're evaluating making it more widely available.  In the announcement was a link to a...

    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

    September 4, 2019 at 7:48 pm

    #3677358

  • Reply To: SSC Fantasy Football 2019

    Luis Cazares wrote:

    Ray K wrote:

    Luis Cazares wrote:

    I wonder if someone will end up with Andrew Luck and Lamar Miller. Be sure to set your preferences for draft.

    I just looked.  Luck and Miller are...

    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

    September 4, 2019 at 6:25 pm

    #3677332

  • Reply To: SSC Fantasy Football 2019

    Ray K wrote:

    Luis Cazares wrote:

    I wonder if someone will end up with Andrew Luck and Lamar Miller. Be sure to set your preferences for draft.

    I just looked.  Luck and Miller are so...

    • This reply was modified 6 years, 9 months ago by Luis Cazares.
    • This reply was modified 6 years, 9 months ago by Luis Cazares.

    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

    September 3, 2019 at 5:00 pm

    #3676946

  • Reply To: SSC Fantasy Football 2019

    I wonder if someone will end up with Andrew Luck and Lamar Miller. Be sure to set your preferences for draft.

    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 30, 2019 at 5:30 pm

    #3675807

  • Reply To: Are the posted questions getting worse?

    Steve Jones - SSC Editor wrote:

    Luis Cazares wrote:

    It's been good. We're still waiting for our baby girl to decide to be born. She's taking her time. (Yesterday was the "due date")

    I'm assuming by now congratulations...

    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 22, 2019 at 1:14 am

    #3673334

  • Reply To: Are the posted questions getting worse?

    jasona.work wrote:

    And yet another week of dealing with the "anti-virus" virus...

    ...

    So how was your day?

    It's been good. We're still waiting for our baby girl to decide to be born. She'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

    August 16, 2019 at 4:02 pm

    #3671899

  • Reply To: Are the posted questions getting worse?

    Sean Lange wrote:

    Yes I agree this website is slowing down. Not just performance but activity as well.

    On another topic of slow...here was this last weekends goods from the smoker.

     

      <li style="list-style-type:...

    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 14, 2019 at 2:09 pm

    #3671327

  • Reply To: How to identify if data is skewed in a table

    How many rows are you returning? How many are there in the table?

    Follow the suggestions on this article to get better help on performance problems.

    https://www.sqlservercentral.com/articles/how-to-post-performance-problems-1

    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 7, 2019 at 8:49 pm

    #3669664

Viewing 15 posts - 106 through 120 (of 8,731 total)