Forum Replies Created

Viewing 15 posts - 12,616 through 12,630 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/2/2010)

    Steve Jones - Editor (9/2/2010)

    I'd send them a business card. $100/hr, be happy to work over RDP and install SQL for you.

    Steve, you left out the minimum 4...

    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

    September 2, 2010 at 2:47 pm

    #1215933

  • RE: How to disable all foreign keys in a database ?

    SQL Guy-482125 (9/2/2010)

    That's a good question. Actually that exercise was like a "rehearsal" before deployment to production. There were too many errors, so we ran same things until install...

    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

    September 2, 2010 at 2:45 pm

    #1215931

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/2/2010)

    Alvin Ramard (9/2/2010)

    Lynn Pettis (9/2/2010)

    Looks like I've missed something on forums the past couple of days. I've been fighting a cold/allergies plus the new job, just haven't...

    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

    September 2, 2010 at 1:04 pm

    #1215864

  • RE: Are the posted questions getting worse?

    WayneS (9/2/2010)

    Alvin Ramard (9/2/2010)

    Make that 25.3/day

    DECLARE @PostCount AS INT

    SET @PostCount = 18052

    SELECT CONVERT(NUMERIC(5,1), (20000.0 - @PostCount)/ DATEDIFF(DAY, GETDATE(), '2010-11-18'))

    Looks like we made today's quote, just figuring out how to do...

    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

    September 2, 2010 at 12:23 pm

    #1215837

  • RE: Upgradation frm SQL 2k to 2k5

    sushantkumar1984 (9/2/2010)

    Hi,

    I hav sql server 2000 SP4 on windows 2003. I want to upgrade it to SQL 2005.

    I installed the cd of sql 2005 enterprise edition,...

    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

    September 2, 2010 at 12:18 pm

    #1215833

  • RE: Upgradation frm SQL 2k to 2k5

    sqlbuddy123 (9/2/2010)

    Hi Sushanth,

    As alvin said there is no going backwards...

    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

    September 2, 2010 at 12:17 pm

    #1215830

  • RE: How to disable all foreign keys in a database ?

    WayneS (9/2/2010)

    CirquedeSQLeil (9/2/2010)

    Ok. What if you need to do this after it rolls to production?

    Just drop the tables, add them, add the data, add the FKs. 😛 ;-)...

    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

    September 2, 2010 at 12:12 pm

    #1215825

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/2/2010)

    Jason, you can keep an eye on that 2005 upgrade if you want. I'm running for cover.

    Would you let someone who's not sure how to install SQL...

    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

    September 2, 2010 at 12:12 pm

    #1215824

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/2/2010)

    CirquedeSQLeil (9/2/2010)

    Grant Fritchey (9/1/2010)

    CirquedeSQLeil (9/1/2010)

    Grant Fritchey (9/1/2010)

    GSquared (9/1/2010)

    Connections via SSC and LinkedIn have got my phone ringing off the hook (well, the phone isn't old enough to do...

    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

    September 2, 2010 at 11:58 am

    #1215813

  • RE: Upgradation frm SQL 2k to 2k5

    Default - if that is what your initial instance in 2K was.

    You need to make sure you are running upgrade and not just the regular install.

    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

    September 2, 2010 at 11:51 am

    #1215803

  • RE: How to disable all foreign keys in a database ?

    Ok. What if you need to do this after it rolls to production?

    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

    September 2, 2010 at 11:50 am

    #1215800

  • RE: Job Duration

    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

    September 2, 2010 at 11:48 am

    #1215795

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/2/2010)

    Lynn Pettis (9/2/2010)

    Alvin Ramard (9/2/2010)

    CirquedeSQLeil (9/2/2010)

    jcrawf02 (9/2/2010)

    Tom.Thomson (9/2/2010)

    Steve Jones - Editor (9/2/2010)

    Noooooooo, not partial posts. There can be enough nonsense in this thread already.

    Surely you don't expect all...

    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

    September 2, 2010 at 11:47 am

    #1215794

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/1/2010)

    CirquedeSQLeil (9/1/2010)

    Grant Fritchey (9/1/2010)

    GSquared (9/1/2010)

    Connections via SSC and LinkedIn have got my phone ringing off the hook (well, the phone isn't old enough to do that literally, 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

    September 2, 2010 at 11:45 am

    #1215791

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/2/2010)

    CirquedeSQLeil (9/2/2010)

    jcrawf02 (9/2/2010)

    Tom.Thomson (9/2/2010)

    Steve Jones - Editor (9/2/2010)

    Noooooooo, not partial posts. There can be enough nonsense in this thread already.

    Surely you don't expect all the posts to be...

    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

    September 2, 2010 at 11:40 am

    #1215785

Viewing 15 posts - 12,616 through 12,630 (of 19,560 total)