Forum Replies Created

Viewing 15 posts - 4,651 through 4,665 (of 6,035 total)

  • 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

  • RE: Today's Random Word!

    Ed Wagner (3/17/2014)


    Eric M Russell (3/17/2014)


    inauguration

    Start

    dissonance

  • RE: Today's Random Word!

    inauguration

  • RE: Transaction timeout happening on inserting huge data

    Even on a low end server, it shouldn't take 10 minutes to insert 90,000 rows into one table and 5,000 rows into another one. I suspect what's holding it up...

  • RE: getting results from all tables in database

    navie (3/13/2014)


    ...

    I need to get result from all the tables and all the columns which has bad data including schemaName, table name and column name in result.

    thanks,

    I work with...

  • RE: Read and Write speeds not increased with additional disks.

    william.rees.howells (3/13/2014)


    Does anybody know why I see absolutely no performance improvement when I spread my primary file group over 8 separate files on 8 separate disks, as opposed to...

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

    humbleDBA (3/14/2014)


    Eric M Russell (3/13/2014)


    Siberian Khatru (3/12/2014)


    I have a table with @ 20 Million rows of data I want to truncate or delete. I don't need any of the...

Viewing 15 posts - 4,651 through 4,665 (of 6,035 total)