Forum Replies Created

Viewing 15 posts - 46 through 60 (of 1,251 total)

  • Reply To: Database Compression Settings

    Steve Jones - SSC Editor wrote:

    What's tricky here? The "ensure"

    The comments don't really explain what you mean.

    I  was trying to be a bit circumspect to avoid giving away the answer so it's fair enough...

    • This reply was modified 4 years, 9 months ago by Neil Burton. Reason: Edited for clarity

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    September 6, 2021 at 6:43 am

    #3927093

  • Reply To: Database Compression Settings

    frederico_fonseca wrote:

    tricky as based on the way it was phrased there are 2 right answers

    I agree.  There's an implication in the question that caught me out.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    September 3, 2021 at 9:12 am

    #3926584

  • Reply To: Are the posted questions getting worse?

    My internet died last night and I've had to come to the office because it's still not back!

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    July 23, 2021 at 7:52 am

    #3913089

  • Reply To: Are the posted questions getting worse?

    We were supposed to be back in the office from Monday but with the advice from the government changing from "go back to the office everybody" to " go back...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    July 22, 2021 at 2:19 pm

    #3912883

  • Reply To: Are the posted questions getting worse?

    Eirikur Eiriksson wrote:

    Jeff Moden wrote:

    Brandie Tarvin wrote:

    YES!

    "Nice to have: 2k years experience with DBCC TIMEWARP()."

    And then sit back and see how many people actually respond. @=)

    BWWWWWWAAAAA-HAAAAAA-HAAAAAA!!!!

    That made my whole week!  Thanks for the...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    July 6, 2021 at 6:21 am

    #3903776

  • Reply To: Are the posted questions getting worse?

    Lynn Pettis wrote:

    Steve Collins wrote:

    Spam is one thing but don't let anyone convince you to try scrapple.  It's not "the same thing" it's not even "similar" 🙂

    My father in-law made scrapple, and...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    March 9, 2021 at 7:36 am

    #3855306

  • Reply To: Distinguish Between Identical Rows

    Jonathan AC Roberts wrote:

    So you are just trying to make sure you don't load the same file twice. Maybe if you create another table of all the files you have loaded, insert...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    March 5, 2021 at 3:47 pm

    #3853878

  • Reply To: Distinguish Between Identical Rows

    ScottPletcher wrote:

    I think you need to add the file "key" -- to identity the unique file being loaded -- to the data file to distinguish between rows.  That doesn't violate...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    March 5, 2021 at 3:44 pm

    #3853877

  • Reply To: Distinguish Between Identical Rows

    Jonathan AC Roberts wrote:

    Why are you worried about getting duplicates?

    If you make sure the same file isn't loaded twice then would that solve your problem?

    It's not the "duplicates" within a file that...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    March 5, 2021 at 3:13 pm

    #3853857

  • Reply To: Distinguish Between Identical Rows

    I think you've got what I mean and that kind of query would be my first choice.  But here's the rub, there will be rows in the main table like...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    March 5, 2021 at 2:45 pm

    #3853845

  • Reply To: Are the posted questions getting worse?

    Ok, own up, which one of us was it?

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 15, 2021 at 10:10 am

    #3833700

  • Reply To: Are the posted questions getting worse?

    Ed Wagner wrote:

    Sean Lange wrote:

    So we have this third party shipping system that is...well...user hostile at best. To add insult to injury for the users the system has been suffering increased performance...

    • This reply was modified 5 years, 5 months ago by Neil Burton.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 15, 2021 at 7:38 am

    #3833674

  • Reply To: Change name of a particular step in an existing SQL Agent Job

    You can use sp_update_jobstep.  Are you sure you can't do it in SSMS?  If you open the properties tab of the step in question you can edit the Step...

    • This reply was modified 5 years, 5 months ago by Neil Burton.
    • This reply was modified 5 years, 5 months ago by Neil Burton.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    December 24, 2020 at 7:26 am

    #3823735

  • Reply To: Execution Log Clean Up

    Jeff Moden wrote:

    Neil Burton wrote:

    My boss manually deleted the backlog in chunks on Friday and things appear to have been fine over the weekend.  I'll know a bit more definitely when the...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    December 15, 2020 at 7:29 am

    #3820570

  • Reply To: Are the posted questions getting worse?

    jasona.work wrote:

    Found out the other week, we're likely to be working from home to the end of June 2021...

    So I splurged and bought myself a new, more adjustable desk chair...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    December 15, 2020 at 7:14 am

    #3820567

Viewing 15 posts - 46 through 60 (of 1,251 total)