Forum Replies Created

Viewing 15 posts - 31 through 45 (of 1,251 total)

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

    If you have access to the log files taken using Commvault, why can't you use some homegrown method to restore those to your target database?  We use the OH scripts...


    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: Restoring a Certificate

    There appears to be a typo in the question in that it asks for "what command" but there are apparently two correct answers.  The answers have tick boxes which suggests...


    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?

    Guess how my f$%^ing Saturday has started too.


    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?

    frederico_fonseca wrote:

    Michael L John wrote:

    Is it Friday?  I feel like it should be Friday.

    No... its Sunday... special extended weekend 🙂

    Now it's Friday.  Mine started especially early too with a callout 45 minutes...


    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: Today's Random Word!

    Cove


    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: Do we now need to be full developers?

    I can't speak about becoming full developers but we're currently in the process of migrating to AWS.  As part of this, I've found myself building Windows Failover Clusters and working...


    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: GDPR and Backups

    Grant Fritchey wrote:

    One, please, always, despite this being a technical question, talk to someone in legal at your organization after you decide on a path forward.

    Two, I've been studying this for...


    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: Posted in the Wrong Forum

    .


    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?

    below86 wrote:

    Jeff Moden wrote:

    Heh... mine has started off with a bit of a "well that sucks" factor.  Whole new time-keeping system where they want me to categorize virtually every aspect of...

    • This reply was modified 4 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

  • Reply To: Are the posted questions getting worse?

    It's a big year for us next year because we're moving into AWS.  The initial migration will be like-for-like to maintain consistency but there's going to be the opportunity to...


    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: Getting Beyond Passwords

    One of my domain passwords expired yesterday so I asked the service desk to reset it for me.  I then spent half an hour trying to create a password 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

  • Reply To: Arithmetic overflow error converting expression to data type datetime when selec

    When you say the PDWEDT column is numeric, how exactly is it stored?  Your code returns '2021-11-28 hh:mm:ss.nnn' as  last Sunday with the precise time dependent on when the code was...


    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: SQL Agent Driving Me Nuts

    If you're running the .bat file as a Operating system (CmdExec) step, have you tried running it as a SQL Server agent proxy using credentials for a user that has...


    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: positive edge

    You're welcome.  You could also do:

    Create TRIGGER [dbo].[tinsert]

    ON [dbo].[TBL_LiveData]

    AFTER UPDATE

    As

    DECLARE
    @Prozessstart integer = 0 -- An alternative method of setting a variable.
    ,@liveDataValue integer ;

    SELECT @liveDataValue = value...


    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: positive edge

    The basic syntax to set a variable in T-SQL is

    SET @Prozessstart = 0

    Your example is missing the SET in the first two instances where you set your...


    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 - 31 through 45 (of 1,251 total)