Forum Replies Created

Viewing 15 posts - 14,431 through 14,445 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Paul White NZ (4/29/2010)

    Grant Fritchey (4/29/2010)

    Thanks. I'll pass it on if you haven't already.

    I replied on Ask, but thanks for posting the thread reference there too.

    I don't usually post on...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 10:10 am

    #1159863

  • RE: Backup and restore solution for 800TB of data

    GregoryF (4/29/2010)

    The server that could process all of this, and the SAN that could store it, and the networking that can transfer it, would out of reach for all but...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 10:09 am

    #1159862

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/29/2010)

    Guys, go and check this out. Either we have a measuring error or this guy is dealing with the single largest SQL Server installation I've heard about.

    He's backing...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 10:06 am

    #1159859

  • RE: Backup and restore solution for 800TB of data

    GilaMonster (4/29/2010)

    Get a professional in. There are going to be very few people with experience in databases over a few TB and an 800TB has to be one of the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 10:06 am

    #1159858

  • RE: Backup and restore solution for 800TB of data

    Steve Jones - Editor (4/29/2010)

    It can be 800TB, but that is huge. Are you sure you're not mistaking the size by a factor of 10?

    Also, I'm curious how you are...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 10:04 am

    #1159857

  • RE: Are the posted questions getting worse?

    tosscrosby (4/29/2010)

    Lynn Pettis (4/28/2010)

    And the school work continues.

    That time of year, final papers/projects due. Cheap, easy way out. Pity the poor company who sees a degreed young person...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 9:59 am

    #1159852

  • RE: MCJ - The Missing Link

    Steve Jones - Editor (4/29/2010)

    I went back and looked at the wording in Jeff's draft. The issue there is that many of us borrow code for others and use it....

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 9:55 am

    #1159847

  • RE: Drop and recreate vs alter stored procedure

    Grant Fritchey (4/29/2010)

    david.wright-948385 (4/29/2010)

    Another advantage of "create/alter" over "drop/create" is that the latter leaves the database without the object for a (usually short) amount of time.

    True, but since it's usually...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 9:50 am

    #1159845

  • RE: Help me to write a query

    Grant Fritchey (4/29/2010)

    It was answered over there.

    It would have been nice to have had it posted it here along with the answer.

    Glad it was answered:rolleyes:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 9:48 am

    #1159839

  • RE: Bad data import

    Great question. I learned something from this one.

    Nice job.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 9:47 am

    #1159838

  • RE: Permissions to 100+ tables

    Ratheesh.K.Nair (4/28/2010)

    Thanks Everyone

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 29, 2010 at 9:44 am

    #1159833

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (4/28/2010)

    Hate the UK. It's not the US 😉

    LOL

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 28, 2010 at 10:07 pm

    #1159399

  • RE: Drop and recreate vs alter stored procedure

    alen teplitsky (4/28/2010)

    see it now

    only has a modified date though. a DDL trigger will have the actual SQL of the change. we have it in the tickets opened for the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 28, 2010 at 7:33 pm

    #1159374

  • RE: Are the posted questions getting worse?

    Tom.Thomson (4/28/2010)

    CirquedeSQLeil (4/28/2010)

    Thus, don't ever log out and your visit will stay low (so long as the cookie doesn't expire).

    That's right.

    And you got in fast there Jason, before I corrected...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 28, 2010 at 6:48 pm

    #1159366

  • RE: Backup schedules

    And why the differential backup now? It is apparent that the tlogs are being used as the diff and loss of data is permissible.

    I would consider revising the entire...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 28, 2010 at 6:46 pm

    #1159365

Viewing 15 posts - 14,431 through 14,445 (of 19,560 total)