Forum Replies Created

Viewing 15 posts - 17,116 through 17,130 (of 19,560 total)

  • RE: FOR XML PATH

    Nice question.

    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

  • RE: Are the posted questions getting worse?

    When will we see books from Jack, Lynn and Gus?

    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

  • RE: Which account should the maintenance plans run under?

    AndrewSQLDBA (2/18/2010)


    You should never use the sys admin account for anything. That is only for backwards compatibility. Not sure why it is even still in here.

    Create a simple SQL user...

    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

  • RE: Are the posted questions getting worse?

    Interesting site bouncing around twitter today by the MVPs.

    Decided to check out

    http://www.uservoice.com

    signed up under http://sqlrnnr.uservoice.com

    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

  • RE: Are the posted questions getting worse?

    Woohoo - finally made it to 5000 :w00t:

    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

  • RE: SQL Server 2008 running 50% faster on desktop than server - what to look for?

    isuckatsql (2/18/2010)


    In the activity monitor on the Server i have Waiting Tasks(7)....whatever that means ?

    I have Waiting Tasks(0) on the desktop.

    Waiting Tasks

    The number of tasks that are waiting for processor,...

    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

  • RE: How to modify 'system stored procedure' SQL 2008?

    Gail, Barry, and Elliott have put it very succinctly.

    If you really want slightly different performance from one of the system procs, create on of your own that fills that requirement...

    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

  • RE: DBCC Timewarp

    Robert Davis (2/18/2010)


    Forget DBCC TimeWarp. I just discovered DBCC PayIncrease.:-P

    ahh but DBCC Payincrease requires DBCC Timewarp in order to function properly.

    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

  • RE: Emergency!!!!!!!! Production Databases

    dennisengel (2/18/2010)


    Sorry for replying so late, Thanks everyone for your suggestions.

    Step 1: I had restored these databases to another server from backups, and kept business going. I has good...

    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

  • RE: Emergency!!!!!!!! Production Databases

    GilaMonster (2/18/2010)


    GT-897544 (2/18/2010)


    GilaMonster (2/18/2010)


    GT-897544 (2/18/2010)


    If that is the status values for suspect databases. Looks like it is a clean shut down, no corrupt files.

    It's not.

    Cleanly shutdown is indicated by...

    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

  • RE: passed 70-432

    ss-457805 (2/18/2010)


    i have reported it.. Hopefully this will get deleted soon.

    As the posts now stand - no violation of NDA has occurred. I wouldn't sweat 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

  • RE: Are the posted questions getting worse?

    GilaMonster (2/18/2010)


    Lynn Pettis (2/18/2010)


    Is that per month??

    Yes, both the price and the download limit. Have edited to make that clearer.

    In case it's not obvious, that's not aimed at the individual...

    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

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/18/2010)


    GilaMonster (2/18/2010)


    CirquedeSQLeil (2/18/2010)


    Already started the packages - should I send them by swallow to Gail?

    Pigeon or smoke signal please. Swallows exceed the internet speed limit in this part...

    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

  • RE: Emergency!!!!!!!! Production Databases

    Lynn Pettis (2/18/2010)


    ...

    You know, the 4th, 5th, and 6th posts in this thread asked the right FIRST question, what is in the error logs.

    When you put 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

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/18/2010)


    I just wish the OP would check/post what is in the error logs. That could help answer many questions and provide him with some valuable responses in...

    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

Viewing 15 posts - 17,116 through 17,130 (of 19,560 total)