Forum Replies Created

Viewing 15 posts - 556 through 570 (of 984 total)

  • RE: SQL DB is in redo/undo phase while restoring for more than 3 HRs on SQL 2016

    Terje Hermanseter (8/2/2016)


    You can check the status of your restore operation with the dynamic managment view sys.dm_exec_requests

    To view only RESTORE/BACKUP operations you can include a where clause:

    SELECT *

    FROM sys.dm_exec_requests

    WHERE command...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: How Far Have You Traveled for a SQL Saturday?

    For just one day? The only time I did this it was to SQLBits 7 in York, about an hour from home. But that was the first one...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: Check the validity of SQL Server backups.

    John Mitchell-245523 (7/28/2016)


    Build the verification into your backup job, so it's done as soon as the backup is made.

    By the way, VERIFYONLY only checks the file header. You might...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: AlwaysOn error

    harshavardhan.i (7/28/2016)


    While creating AlwaysOn with 2 nodes, I am getting the below error. Please find the below screenshot. Kindly help. TIA

    Is this the image you mean?

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: How do you know when it is time to leave a job?

    ZZartin (7/27/2016)


    GilaMonster (7/27/2016)


    Eric M Russell (7/27/2016)


    It can be especially difficult for an organization when the recruiting effort is too focussed on conformity and cultural fit rather than experience and talent...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: Are the posted questions getting worse?

    BrainDonor (7/28/2016)


    Lynn Pettis (7/26/2016)


    Haven't seen the UK Kitchen spam in a while.

    You just had to, didn't you?

    <<snip>>

    Has nobody ever told you - CandyMan, CandyMan, Cand....

    I prefer Beetlejuice, Beetlejuice, Beetl....

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: Checking if a string value includes a value from a field

    DSC123 (7/27/2016)


    Morning all,

    Please could someone advise me on the correct syntax for highlighting if an email address includes a year of birth?

    So far I have created the following, the last...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: delete spamming Account please

    From the SSC homepage:

    Welcome to SQLServerCentral.com

    A Microsoft SQL Server community of 1,863,531 DBAs, developers and SQL Server users

    The spam does make me wonder how many of those 1.86M DBAs are...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/26/2016)


    Haven't seen the UK Kitchen spam in a while.

    You're welcome.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: T-SQL formatting tool

    DBA From The Cold (7/19/2016)


    Had a look at SQL prompt, bit pricey for a formatter isn't it?

    Yes, if that was all it does, it would be a bit pricey... ...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: Are the posted questions getting worse?

    BrainDonor (7/26/2016)


    I need chocolate. Decent chocolate.

    Likewise.

    I'm getting a bit spoiled in terms of The Good Stuff at the moment, as the boss of a local chocolate house[/url] used to work...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: Are the posted questions getting worse?

    TomThomson (7/24/2016)


    Jeff Moden (7/15/2016)


    Ray K (7/14/2016)


    Brandie Tarvin (7/14/2016)


    I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)

    I once had...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: Cannot Execute SQL Configuration Manager

    Thinking out loud... Is it possible that this is because you've installed an earlier version of the software (SQL2012) after installing SQL2014? I have vague memories of having...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: Weird backup error. Should I be worried?

    Brandie Tarvin (7/22/2016)


    ThomasRushton (7/22/2016)


    I see this (and minor variations thereof) regularly; unfortunately, our infrastructure guys aren't able to provide me with any information about what's causing the problem...

    ...and are dangling...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • RE: Weird backup error. Should I be worried?

    I see this (and minor variations thereof) regularly; unfortunately, our infrastructure guys aren't able to provide me with any information about what's causing the problem...

    ...and are dangling the prospect of...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

Viewing 15 posts - 556 through 570 (of 984 total)