Forum Replies Created

Viewing 15 posts - 23,086 through 23,100 (of 26,486 total)

  • RE: PeopleSoft sp_cursorexecute Slow after Upgrade to 2005

    Run the following query on you system(s) and let us know the results for your PeopleSoft databases.

    select

    name,

    snapshot_isolation_state,

    snapshot_isolation_state_desc,

    ...

    January 7, 2009 at 9:40 pm

    #923067

  • RE: UPDATE from CTE

    RBarryYoung (1/7/2009)

    Joe Celko (1/7/2009)

    >> Why do you have to be so acerbic? Not a good way to make friends and influence people. <<

    Quit being a whining child who...

    January 7, 2009 at 9:23 pm

    #923065

  • RE: UPDATE from CTE

    Mr. Celko,

    First, I'm not whining, far from it. I am simply pointing out a basic observation based on reading many of your posts both here on SSC and else...

    January 7, 2009 at 5:52 pm

    #923014

  • RE: Are the posted questions getting worse?

    Jeff,

    I sent the article to Steve this morning. Thank you for the feedback and the compliments! It makes doing the writing that much more fulfilling.

    Lynn

    January 7, 2009 at 4:54 pm

    #923002

  • RE: Confusion with int

    anam (1/7/2009)

    Can't find any explanation behind it. Can anybody please explain me why the results of two select statements are same. I wasn't expecting same results from both of these...

    January 7, 2009 at 4:50 pm

    #922999

  • RE: Are the posted questions getting worse?

    bitbucket (1/7/2009)

    A question for Lynn Pettis

    I like the open space here in Colorado, even though Colorado Springs does seem to keep growing.

    A long long time ago (no not the opening...

    January 7, 2009 at 4:40 pm

    #922997

  • RE: How to change output format

    Read about PIVOT in Books Online, and start with that. If you still have questions, let us know.

    January 7, 2009 at 4:06 pm

    #922984

  • RE: UPDATE from CTE

    Mr. Celko, Why do you have to be so acerbic? Not a good way to make friends and influence people. Also, your notion of truly portable code? ...

    January 7, 2009 at 3:51 pm

    #922977

  • RE: Deny UPDATE statement

    If all they need to do is select data from tables, the only permission they should have in the database db_reader. What permissions do they currently have to the...

    January 7, 2009 at 3:28 pm

    #922966

  • RE: sql query

    GilaMonster (1/7/2009)

    Lynn Pettis (1/7/2009)

    GilaMonster (1/7/2009)

    Lynn Pettis (1/7/2009)

    hmmm, a question I sense here but not sure what you want.

    Are you channelling Yoda again?

    Sorry, caught a couple of the Star Wars movies...

    January 7, 2009 at 3:16 pm

    #922957

  • RE: sql query

    GilaMonster (1/7/2009)

    Lynn Pettis (1/7/2009)

    hmmm, a question I sense here but not sure what you want.

    Are you channelling Yoda again?

    Sorry, caught a couple of the Star Wars movies on TV this...

    January 7, 2009 at 1:36 pm

    #922882

  • RE: SQL Server 2005 SP 3

    jncarter,

    Thank you for the time you took with your response. Unfortunately, I don't think it applies in this case. I just finished search the log files for a...

    January 7, 2009 at 1:34 pm

    #922879

  • RE: How To Quickly Ramp Up on SSIS?

    One book I recommend is Worx Professional SQL Server Integration Services 2005. It is the book I keep on hand when working on SSIS packages and is the one...

    January 7, 2009 at 12:58 pm

    #922846

  • RE: sql query

    hmmm, a question I sense here but not sure what you want.

    Please read the article linked below regarding asking for help. If you follow the guidelines in that article,...

    January 7, 2009 at 12:22 pm

    #922821

  • RE: SSIS merge join transform does not return all rows

    barbaran (1/7/2009)

    I attached an image of the data flow.

    SELECT Key

    FROM databaseA.tableA (400,000 rows)

    SELECT Key

    , value

    FROM database1.table1 (1,200,000 rows)

    MERGE JOIN ON Key

    86,000 records are known to match, the number...

    January 7, 2009 at 12:19 pm

    #922815

Viewing 15 posts - 23,086 through 23,100 (of 26,486 total)