Forum Replies Created

Viewing 15 posts - 11,551 through 11,565 (of 19,560 total)

  • RE: Not executing in sql2008-collation error

    What is the collation of each?

    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

    November 29, 2010 at 11:02 pm

    #1256599

  • RE: Error in Event Viewer

    See if this is of use for your situation.

    http://support.microsoft.com/kb/937745

    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

    November 29, 2010 at 10:56 pm

    #1256598

  • RE: Help with Performance

    Both of the provided links are great resources.

    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

    November 29, 2010 at 10:54 pm

    #1256595

  • RE: unable to Kill a Process

    I would imagine it is in how you are issuing the kill command.

    It sounds like you may be issuing a

    Kill -61

    And should be issuing a

    Kill 61

    Here is some info...

    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

    November 29, 2010 at 10:50 pm

    #1256594

  • RE: Not executing in sql2008-collation error

    What is the last version of SQL server you had that script working under?

    What was the collation of that server?

    What is the collation of the current SQL 2008 server?

    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

    November 29, 2010 at 10:45 pm

    #1256593

  • RE: badly need help

    GilaMonster (11/29/2010)

    Do not even consider touching the system tables. They are not there for you to edit. There's a reason that 'allow updates' doesn't work on SQL 2005+. Also note...

    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

    November 29, 2010 at 10:42 pm

    #1256592

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/29/2010)

    CirquedeSQLeil (11/29/2010)

    Jeff Moden (11/29/2010)

    WayneS (11/29/2010)

    CirquedeSQLeil (11/29/2010)

    On the flip-side, I see your point and think that weekends are the times for doing deployments. Less impact to the business...

    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

    November 29, 2010 at 10:40 pm

    #1256590

  • RE: badly need help

    I am curious why you would need to modify the date field in this way. It seems like there is some covering of a mistake going on. Please...

    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

    November 29, 2010 at 10:38 pm

    #1256589

  • RE: badly need help

    sys.tables and sys.objects are SQL 2005 and above.

    For SQL 2000, they are sysobjects and systables. I recommend not altering any of the MS Shipped schemas.

    There are also many methods...

    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

    November 29, 2010 at 6:07 pm

    #1256556

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/29/2010)

    WayneS (11/29/2010)

    CirquedeSQLeil (11/29/2010)

    On the flip-side, I see your point and think that weekends are the times for doing deployments. Less impact to the business and make sure...

    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

    November 29, 2010 at 4:43 pm

    #1256547

  • RE: Ready for Inspection

    WayneS (11/29/2010)

    Steve Jones - SSC Editor (11/29/2010)

    Your job ought to be well documented, ready for inspection, or more likely, ready for someone else in case you get hit by 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

    November 29, 2010 at 3:31 pm

    #1256531

  • RE: Analyzing Product Growth with the Management Data Warehouse

    Thanks for the article.

    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

    November 29, 2010 at 3:26 pm

    #1256530

  • RE: Are the posted questions getting worse?

    Tom.Thomson (11/29/2010)

    CirquedeSQLeil (11/29/2010)

    On the flip-side, I see your point and think that weekends are the times for doing deployments. Less impact to the business and make sure we have...

    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

    November 29, 2010 at 3:23 pm

    #1256528

  • RE: When the instance was running on which node?

    To find what happened in the past, you will have to comb through event logs.

    For going forward, you could implement a process/job that writes that info out to a table...

    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

    November 29, 2010 at 3:20 pm

    #1256527

  • RE: Star Wars

    My 4 and 3 yr olds watch episodes 4,5,6,1, and 2 on a regular basis. I haven't let them watch the DVD for 3 yet due to the burning...

    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

    November 29, 2010 at 3:14 pm

    #1256524

Viewing 15 posts - 11,551 through 11,565 (of 19,560 total)