Forum Replies Created

Viewing 15 posts - 31 through 45 (of 39,736 total)

  • Reply To: Rollback vs. Roll Forward

    skeleton567 wrote:

    Backward or forward? I would say it depends.

    I think the most important skill for us DBA's, maybe even more than technical, is critical thinking under pressure. The ability to...

  • Reply To: When to add indexes suggested from the DMVs

    Not going to download a random file. Post the code. Most indexes will be nonclustered that are added.

  • Reply To: Rollback vs. Roll Forward

    Chris Wooding wrote:

    I think fix-forward is the more common option when the issue has gone undetected for a period of time so that further processing has taken place that would be...

  • Reply To: Rollback vs. Roll Forward

    Mark Dalley wrote:

    From the safety of my armchair, with no current emergency to disturb my reasoning, I would say: Get the DB to a Known State. And this will almost always...

  • Reply To: Detecting Issues

    For me, I point out things I've did and give an analysis of what could be better, or would have prevented issues.

    The more I document and point things out, the...

  • Reply To: A Quick Restore

    webrunner wrote:

    Thanks for the question, Steve!

    Is the correct answer due to the fact that the restore is attempted while in the DNRTest database itself?

    Thanks,

    webrunner

    Yes, the db is in use, so...

  • Reply To: String Similarity I

    Sorry, typo here. Mixed up the explanation with another question in a poor copy/paste error.

    The distance is 10. Points awarded back

  • Reply To: connections vs apis

    stan wrote:

    thx dbruton, i have a feeling that when folks throw micro services at challenges like this to push rather than pull data, its completely possible that pooling isnt happening. ...

  • Reply To: Are the posted questions getting worse?

    For sure. If you're not testing restores, you don' tknow the backups are really working.

    I've seen people have issues, especially if they inherit a system that doesn't use with init....

  • Reply To: connections vs apis

    I've had a few customers do this and they just move the load. Unless the API server caches results for its connections, you still have a lot of queries to...

  • Reply To: SSMS 22 Latest Update Crashing

    This wasn't a Prompt stability issue. Prompt releases every week, and you can delay updates.

    However, Microsoft changed the version or name (can't remember) of some libraries that lots of add-ins...

  • Reply To: Engineer Lessons

    Ross McMicken wrote:

    From my world with respect to team work:

    If you don't share your skills and knowledge I do not want to work with you. You won't be here forever and...

  • Reply To: Doing Good at SQL Server Central

    Thanks and you are right. The things I remember most are the people and moments we've shared that made a difference, however big or small.

  • Reply To: 25 Years Later: What SQLServerCentral Meant to Me

    This is a great piece, Brian and I agree. Communities change lives, and it's been amazing to see what you've done with Pragmatic Works as well, helping people in your...

  • Reply To: Engineer Lessons

    Agree with David. Sometimes it results in nothing, but it pays dividends later. The less quid pro quo and the more do the right thing, the better you are.

Viewing 15 posts - 31 through 45 (of 39,736 total)