Forum Replies Created

Viewing 15 posts - 4,636 through 4,650 (of 6,026 total)

  • RE: Alas Poor Snapshot, I Knew Him Well

    I would finish my burrito, sitting in Chipolte, regardless. I'd put Junior on the cell phone speaker, ask him to describe the error, and then help guide him through it;...

  • RE: EXCEL-SQLServer - Is is possible to force isolation level read uncommited for specific logins ?

    Setting isolation level within login trigger won't work, the scope will only be within trigger and won't apply to session.

    This is a shot in the dark, not hopeful, but...

  • RE: EXCEL-SQLServer - Is is possible to force isolation level read uncommited for specific logins ?

    NicoNicoNico38 (3/20/2014)


    Hello,

    Thanks a lot for your answer...

    But i do not control the TSQL written in Excel by users ...

    They have a login/password, they connect via Excel to SQL Server...

  • RE: Alas Poor Snapshot, I Knew Him Well

    OCTom (3/20/2014)


    Should Junior have been capable of figuring this out from the error message? Or, is this too much to ask of a Junior? And, if it's too much to...

  • RE: EXCEL-SQLServer - Is is possible to force isolation level read uncommited for specific logins ?

    NicoNicoNico38 (3/20/2014)


    Hello,

    Do you if it is possible to set isolation levels read uncommited for specific logins on an Instance or via ODBC driver configuration ?

    Some users connect to SQL Server...

  • RE: Alas Poor Snapshot, I Knew Him Well

    "The revert operation failed!"

    The first question I'd ask: What is the error message? It's pretty clear.

    Msg 3137, Level 16, State 4, Line 1

    Database cannot be reverted. Either...

  • RE: Merge two big datasets

    HaraPriya (3/19/2014)


    I have two datasets one of 15000+ records and other with 5000+ records.I need to merge these two sets based on Name which may not be in the same...

  • RE: Audit all databases.

    Steve Jones - SSC Editor (9/4/2013)


    Show how someone can use a DDL trigger to audit all CREATE TABLE statements in all databases on a server.

    Somehow I feel like there...

  • RE: The Worst Code

    David.Poole (3/18/2014)


    My thought question: Have you ever been told that your query runs too fast?

    YES. Our chief exec stood up before the entire company and said that a web...

  • RE: The Worst Code

    Whether the worst code we've ever seen was somebody's elses or ours is not what's important. We have to own our code, just like we own the responsibility of our...

  • RE: Transaction timeout happening on inserting huge data

    sunil88_pal88 (3/18/2014)


    Hi Guys ,

    There is one more thing I forget to tell that on development server ,everything is fine .Data is uploaded in almost 3 minutes, but on production it...

  • RE: I need to delete 20 million rows from a table...

    GilaMonster (3/14/2014)


    Eric M Russell (3/14/2014)


    Well, if it took only 1/2 second to delete 20 million rows, then he's lucky. That's not typical; almost to the point of disbelief.

    TRUNCATE TABLE

    It doesn't...

  • RE: The Worst Code

    Regarding software that comes bundled with hardware, is not the actual software itself, but rather the buggy install package and the stealth marketing crap and spyware that attempts to hook...

  • RE: Today's Random Word!

    JAZZ Master (3/17/2014)


    Ed Wagner (3/17/2014)


    Eric M Russell (3/17/2014)


    JAZZ Master (3/17/2014)


    Daniel Bowlin (3/17/2014)


    Revenant (3/17/2014)


    Eric M Russell (3/17/2014)


    Ed Wagner (3/17/2014)


    Eric M Russell (3/17/2014)


    inauguration

    Start

    dissonance

    discord

    record

    breaker

    Peacemaker

    Cheesemaker (or any maker of dairy products :-D)

    Cheesecake

    Dancer

  • RE: Today's Random Word!

    JAZZ Master (3/17/2014)


    Daniel Bowlin (3/17/2014)


    Revenant (3/17/2014)


    Eric M Russell (3/17/2014)


    Ed Wagner (3/17/2014)


    Eric M Russell (3/17/2014)


    inauguration

    Start

    dissonance

    discord

    record

    breaker

    Peacemaker

Viewing 15 posts - 4,636 through 4,650 (of 6,026 total)