Forum Replies Created

Viewing 15 posts - 136 through 150 (of 1,251 total)

  • Reply To: Log File Growing on Replication Subscriber

    It's transactional replication. We do rebuild indexes on the publisher but they shouldn't get replicated.  The other reason this is unlikely is the timings of the growth events doesn't coincide...


    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

  • Reply To: Are the posted questions getting worse?

    And they've changed their minds.

    • This reply was modified 6 years, 10 months ago by Neil Burton.
    • This reply was modified 6 years, 10 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

  • Reply To: Are the posted questions getting worse?

    Brandie Tarvin wrote:

    Inquiring minds want to know, how many Threadzians are affected by this one?

    https://www.bbc.com/news/business-49263781

    I'm not sure that it's the kind of thing that will affect many people immediately.  It's going...


    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

  • Reply To: Is there a way of populating a report before showing to the user?

    It is indeed possible to do that.  In a nutshell, you need to add the 'OverallTotalPages' built-in field to a header or footer on your report. There's more detail here.

    • This reply was modified 6 years, 10 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

  • Reply To: Is DBA responsible for ETL operations and cube creation in DW design project?

    Jeff Moden wrote:

    Matt Miller (4) wrote:

    While it does depend, in general I'd think that while the DBA might be not responsible for those design items, they likely will be held accountable for them....


    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

  • Reply To: Temporary data and Differential Backup size

    I got the same results as Carlos.

    It logically makes sense that because there has been no net change the differential will only be small but the outcome of my test...


    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

  • Reply To: dput()

    Is it me or are there no correct answers to this?


    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

  • RE: Today's Random Word!

    Ed Wagner - Thursday, March 28, 2019 5:57 AM

    jasona.work - Thursday,...


    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

  • RE: Are the posted questions getting worse?

    ZZartin - Thursday, March 14, 2019 10:56 AM

    Michael L John - Thursday, March 14, 2019 10:40 AM


    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

  • RE: Pulling the Plug

    Mr Celko often quotes  Turkish(?) proverb, 'no matter how far you've gone down the wrong path, turn back.'  

    It's one thing on which I completely agree with him.  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

  • RE: Are the posted questions getting worse?

    ThomasRushton - Monday, February 18, 2019 10:01 AM

    TomThomson - Monday, February 18, 2019 1:54 AM


    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

  • RE: Today's Random Word!

    Ed Wagner - Thursday, February 7, 2019 6:53 AM

    ManicStar - Wednesday, February 6, 2019 9:36 AM


    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

  • RE: How do I convert a uk date in string format to date?

    Lorna-331036 - Thursday, January 31, 2019 6:56 AM

    Thanks guys - I already validate before passing the string.  I also added SET DATEFORMAT...


    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

  • RE: How do I convert a uk date in string format to date?

    Lorna-331036 - Thursday, January 31, 2019 4:46 AM

    Hi
    A user enters a date in uk format (i.e '24/01/2019') into a web form (.net). ...


    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

  • RE: Pass date input parameter as float data type

    But, again, why are you storing date(time)s as a float? That is (probably) only going to bite you in the foot. 

    The OP isn't storing the date as 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

Viewing 15 posts - 136 through 150 (of 1,251 total)