Forum Replies Created

Viewing 15 posts - 121 through 135 (of 320 total)

  • RE: Transaction Log Growth

    Jeff Moden - Sunday, February 18, 2018 4:30 PM

    Mike Scalise - Sunday, February 18, 2018 1:11 PM

  • RE: Transaction Log Growth

    pietlinden - Sunday, February 18, 2018 2:36 PM

    Okay, I'm not a DBA, so take this with a grain of salt.
    What if you...

  • RE: sp_DatabaseRestore

    AlexSQLForums - Monday, February 12, 2018 2:11 PM

    Mike
    Can you post Ola's backup script which you are using?

    Sure. This is the command I'm...

  • RE: sp_DatabaseRestore

    AlexSQLForums - Wednesday, February 7, 2018 5:48 PM

    Hi Mike
    I think you have to specify log directory as well

    EXEC dbo.sp_DatabaseRestore
    @Database...

  • RE: sp_DatabaseRestore

    AlexSQLForums - Wednesday, February 7, 2018 2:57 PM

    Can you post your full and diff backup script?

    Hi Alex,

    I'm not exactly sure what you mean. I...

  • RE: Question about the GO statement

    Each iteration is actually analyzing the values in the table and, depending on what the values are and where they are during that specific iteration will dictate exactly what it...

  • RE: Question about the GO statement

    Ok, I'm not sure if this helps or hurts, but here's a better representation of what I'm trying to do, which includes SELECT statements rather than PRINT statements and utilizes...

  • RE: Question about the GO statement

    All,

    Thanks so much for the thoughtful replies. I know I didn't articulate my actual issue very well but it's partially because it's very complicated and I was hoping...

  • RE: Question about the GO statement

    jasona.work - Wednesday, December 6, 2017 11:41 AM

    Plus, again, being a query, there's nothing to display when your query hits the "

  • RE: Does anyone use views in this way?

    Thanks, everyone, for the suggestions. It's always good to see the myriad ways to solve problems in SQL Server.

  • RE: Odd behavior with views

    Thank you, all, for the replies. I'm going to see if I can get more information about exactly what's going on here. I know the answer with a lot of...

  • RE: Backups and AlwaysOn Availability Groups

    anthony.green - Wednesday, November 8, 2017 8:13 AM

    Mike Scalise - Wednesday, November 8, 2017 7:37 AM

    November 8, 2017 at 8:27 am

    #1967177

  • RE: Backups and AlwaysOn Availability Groups

    Thanks, Sue and Eddie. Really great information!

    Eddie, just so I understand a little better, your statement, "Full backups do not affect the log chain in any way, regardless...

  • RE: Monitor Activity from a 3rd Party App

    Thanks, Kevin,

    And would this allow me to see the net effect of the queries issued by the third-party app? So, for example, LastName in the Person table was...

  • RE: UNION Question

    I can't believe I missed that. I'm just not operating on all cylinders today.

    I hadn't done a distinct or group by on the table(s) before using the union so it...

Viewing 15 posts - 121 through 135 (of 320 total)