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...

    August 2, 2016 at 2:34 am

    #1893150

  • 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...

    July 31, 2016 at 2:55 am

    #1892802

  • 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...

    July 28, 2016 at 8:58 am

    #1892496

  • 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?

    July 28, 2016 at 6:02 am

    #1892449

  • 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...

    July 28, 2016 at 6:00 am

    #1892448

  • 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....

    July 28, 2016 at 1:59 am

    #1892416

  • 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...

    July 27, 2016 at 2:03 am

    #1892200

  • 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...

    July 27, 2016 at 1:38 am

    #1892198

  • 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.

    July 26, 2016 at 12:42 pm

    #1892131

  • 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... ...

    July 26, 2016 at 9:30 am

    #1892085

  • 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...

    July 26, 2016 at 5:58 am

    #1892014

  • 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...

    July 25, 2016 at 1:32 am

    #1891779

  • 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...

    July 22, 2016 at 9:15 am

    #1891609

  • 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...

    July 22, 2016 at 9:07 am

    #1891604

  • 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...

    July 22, 2016 at 7:35 am

    #1891559

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