Forum Replies Created

Viewing 15 posts - 16 through 30 (of 1,251 total)

  • Reply To: Are the posted questions getting worse?

    Perry Whittle wrote:

    anyone finding the posts in last couple months are real Facepalmers

    You should start a thread about 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

    June 19, 2024 at 9:49 am

    #4429660

  • Reply To: Do you listen to music when you work?

    Duplicate post

    • This reply was modified 2 years, 1 months ago by Neil Burton. Reason: Duplicate

    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

    April 25, 2024 at 6:39 am

    #4415260

  • Reply To: Do you listen to music when you work?

    skeleton567 wrote:

    Neil Burton wrote:

    I have the radio on when I'm working at home playing a classic rock station.  As much as anything, it's because I don't like sitting in silence 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

    April 25, 2024 at 6:38 am

    #4415258

  • Reply To: Do you listen to music when you work?

    I have the radio on when I'm working at home playing a classic rock station.  As much as anything, it's because I don't like sitting in silence and it's a...

    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

    April 24, 2024 at 10:40 am

    #4414926

  • Reply To: A New Audit

    Steve Jones - SSC Editor wrote:

    I see it rarely used. I'm sure someone does, but not many

    We started "using" it last year.  The customer insisted that we enabled it when we migrated and upgraded. ...

    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

    February 26, 2024 at 7:46 am

    #4384872

  • Reply To: Adding a PK - I

    There doesn't appear to be an ALTER INDEX statement in the question.  As it is, although I think I know what the answer should be, I don't think it's answerable.

    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 10, 2024 at 8:20 am

    #4359557

  • Reply To: Backing Up Master

    Philosophically speaking, how can "I don't know" be a wrong answer?

    I looked right through the correct answer in the documentation (not enough coffee yet) so I clicked the answer 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

    December 8, 2023 at 7:41 am

    #4342050

  • Reply To: Refreshing a View

    Good question but there's a typo that will catch people 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

    July 17, 2023 at 6:23 am

    #4236989

  • Reply To: How to speed up this query?

    Have you looked at the query execution plan?  There might be some clues as to what is causing the problem in there.  What kind of data volumes are you dealing...

    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 3, 2023 at 10:00 am

    #4225677

  • Reply To: Waitfor Threads

    Jeff Moden wrote:

    You've just gotta love people that give a super low rating to an article or QoTD without leaving a reason.  🙁  I thought this was a great question because...

    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

    April 14, 2023 at 7:19 am

    #4173872

  • Reply To: SQL Server 2022 Restore and DBCompat

    I agree with Frederico.  This

    Databases with a compatibility level of 90, including backups taken on SQL Server 2005 (9.x), are automatically upgraded to a compatibility level of 100 when restored...

    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 17, 2023 at 7:59 am

    #4161811

  • Reply To: RIGHT-JOIN table not fetching all rows in WHERE clause

    Jeff Moden wrote:

    Jonathan AC Roberts wrote:

    I can't say I have ever used RIGHT JOIN. I think it is only in the language for completeness.

    I use it a fair bit in real life.

    Why would...

    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 6, 2023 at 3:13 pm

    #4157321

  • Reply To: RIGHT-JOIN table not fetching all rows in WHERE clause

    This line in the WHERE clause

    AND (hrxoreturn.returndate >= '2023-02-14 00:00:00' and hrxoreturn.returndate <= '2023-02-14 23:59:00')

    changes your RIGHT JOIN to an INNER JOIN.  If you move the line to your JOIN...

    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 6, 2023 at 10:50 am

    #4157233

  • Reply To: How to list sum of values in the specific period

    Have a look into the DATEPART function.  That should point you in the right direction.

    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 3, 2023 at 12:56 pm

    #4133014

  • Reply To: Combining log shipping and regular Transaction log backups

    I'm glad to hear that you've found a solution.  As far as synchronising data during migrations, replication or log-shipping (one way or the other) are probably the most straightforward options. ...

    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 14, 2022 at 1:56 pm

    #4087594

Viewing 15 posts - 16 through 30 (of 1,251 total)