Forum Replies Created

Viewing 15 posts - 601 through 615 (of 984 total)

  • RE: Today's Random Word!

    Stuart Davies (7/5/2016)

    HappyGeek (7/4/2016)

    Ed Wagner (7/4/2016)

    ThomasRushton (7/4/2016)

    HappyGeek (7/4/2016)

    Ray K (7/1/2016)

    whereisSQL? (7/1/2016)

    Grumpy DBA (7/1/2016)

    djj (7/1/2016)

    Manic Star (7/1/2016)

    Ed Wagner (7/1/2016)

    Manic Star (7/1/2016)

    Grumpy DBA (7/1/2016)

    Luis Cazares (7/1/2016)

    Bunnies

    Beach

    Umbrella

    Fancy Drink

    mmmm....beer

    Brew

    IPA

    hops

    malt

    marmite

    toast

    Bread

    Comedy

    Club

    Kitkat

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

    July 5, 2016 at 1:52 am

    #1888385

  • RE: Stored Procedure execution

    Raghavender (7/4/2016)

    TheSQLGuru (7/4/2016)

    It is showing 0% completed when I checked from dm_exec_requests.

    sys.dm_exec_requests only shows percent_complete for a limited subset of queries. The full list is on the MSDN documentation...

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

    July 5, 2016 at 1:50 am

    #1888383

  • RE: Today's Random Word!

    HappyGeek (7/4/2016)

    Ray K (7/1/2016)

    whereisSQL? (7/1/2016)

    Grumpy DBA (7/1/2016)

    djj (7/1/2016)

    Manic Star (7/1/2016)

    Ed Wagner (7/1/2016)

    Manic Star (7/1/2016)

    Grumpy DBA (7/1/2016)

    Luis Cazares (7/1/2016)

    Bunnies

    Beach

    Umbrella

    Fancy Drink

    mmmm....beer

    Brew

    IPA

    hops

    malt

    marmite

    toast

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

    July 4, 2016 at 6:35 am

    #1888289

  • RE: Pattern match postcode area lookup

    There's a nice postcode validator from Peso / Peter Larsson at http://weblogs.sqlteam.com/peterl/archive/2008/08/13/Validate-UK-postcode.aspx

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

    July 1, 2016 at 6:50 am

    #1888077

  • RE: EXEC sp_executesql

    I would use the QUOTENAME() function wrapped around your database name - that'll make sure that it's properly handled when building up dynamic SQL statements like this.

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

    July 1, 2016 at 6:15 am

    #1888071

  • RE: Correct MAXDOP setting

    John Mitchell-245523 (7/1/2016)

    Depends on the workload on the server, whether there are any other instances, etc, etc. I would start with six, test, and adjust as necessary.

    John

    In part, the...

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

    July 1, 2016 at 5:56 am

    #1888061

  • RE: Today's Random Word!

    Ed Wagner (7/1/2016)

    djj (7/1/2016)

    BWFC (7/1/2016)

    ThomasRushton (7/1/2016)

    Ed Wagner (6/30/2016)

    Revenant (6/30/2016)

    TomThomson (6/30/2016)

    djj (6/30/2016)

    HappyGeek (6/30/2016)

    jasona.work (6/30/2016)

    Ed Wagner (6/30/2016)

    Y.B. (6/30/2016)

    Vacation

    Soon

    Now

    Later

    Sometime

    Summertime

    Short

    Trousers

    Donald

    Daisy

    Duke

    Boys

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

    July 1, 2016 at 5:41 am

    #1888055

  • RE: Trouble with Restore The backup set holds a backup of a database other than the existing database.

    could you please provide me with the syntax?

    You've got a big WITH clause in your RESTORE statement which contains lots of options to move files around. Just add another...

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

    July 1, 2016 at 5:39 am

    #1888054

  • RE: Today's Random Word!

    Ed Wagner (6/30/2016)

    Revenant (6/30/2016)

    TomThomson (6/30/2016)

    djj (6/30/2016)

    HappyGeek (6/30/2016)

    jasona.work (6/30/2016)

    Ed Wagner (6/30/2016)

    Y.B. (6/30/2016)

    Vacation

    Soon

    Now

    Later

    Sometime

    Summertime

    Short

    Trousers

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

    July 1, 2016 at 4:24 am

    #1888038

  • RE: Trouble with Restore The backup set holds a backup of a database other than the existing database.

    Welsh Corgi (7/1/2016)

    Thanks John could you kindly provide me with the syntax?

    ermmm.... add "WITH REPLACE" to your command, as documented in the RESTORE documentation?

    Check the impact of WITH REPLACE...

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

    July 1, 2016 at 4:22 am

    #1888037

  • RE: Article Research

    djj (6/30/2016)

    I agree with Brandie that most of the changes are to data.

    Years ago, before review started, a IT staff person did an update without a where clause....

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

    June 30, 2016 at 6:44 am

    #1887848

  • RE: Article Research

    Then there was the place with the very stringent change control process - everything, no matter how minor, had to go through the full CAB.

    Unless you were the Ops team....

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

    June 30, 2016 at 6:38 am

    #1887846

  • RE: Article Research

    Similar to John Mitchell's story, in that external application vendor had full access to a database server that they were maintaining for us. Unfortunately, they had a very heavy-handed...

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

    June 30, 2016 at 6:33 am

    #1887844

  • RE: Today's Random Word!

    Ed Wagner (6/30/2016)

    Revenant (6/29/2016)

    Ed Wagner (6/29/2016)

    Luis Cazares (6/29/2016)

    Ed Wagner (6/29/2016)

    Ray K (6/29/2016)

    Ed Wagner (6/29/2016)

    Manic Star (6/29/2016)

    TomThomson (6/29/2016)

    Revenant (6/29/2016)

    crookj (6/29/2016)

    ThomasRushton (6/29/2016)

    Grumpy DBA (6/29/2016)

    Hugo Kornelis (6/29/2016)

    Wedding

    Crasher

    Party

    Animal

    The Animals

    Geordies

    Visor (star trek reference)

    Dilithium

    Crystals

    Salt

    Pepper

    Cayenne

    Porsche

    Fast

    Furious

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

    June 30, 2016 at 6:23 am

    #1887839

  • RE: Today's Random Word!

    Grumpy DBA (6/29/2016)

    Hugo Kornelis (6/29/2016)

    Wedding

    Crasher

    Party

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

    June 29, 2016 at 8:14 am

    #1887642

Viewing 15 posts - 601 through 615 (of 984 total)