SQL Server Performance

Passing and Receiving tables To/From SP

Discussion in 'SQL Server 2005 General Developer Questions' started by amitm79, Aug 13, 2006.

  1. amitm79 New Member

    Hi All,

    In MSSQL 2000, it was not possible to nest the passing and receving of resultset (table) to multiple nested levels. Is it possible in SQL Server 2005? If yes, please point me to some links confirming the same.

    Regards,
    Amit
  2. Madhivanan Moderator

    Can you give us more information on what you are trying to do?

    Madhivanan

    Failing to plan is Planning to fail
  3. FrankKalis Moderator

    Not sure what you're after but have a look at SQL Server MVP Erland Sommarskogs article about passing data between stored procedures athttp://www.sommarskog.se

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de
  4. amitm79 New Member

    Guys,

    I have a partitioned database and i am accessing them through view. My queries on that view do not run (they give error) if it has more then 255 tables. Otherwise i am quite happy with the performance of my db. I just want to know if i can partition them further.

    Frank,

    The article by Erland is good but i have reservations regarding performance because of xml parsing and all. Let me see if i can find something else which is purely TSQL

    Madhivanan,

    I don't think my question really needs explanation on what i am doing here. I just need to pass and receive recordsets.

    Anyways, thanks all for replying

    Amit
  5. FrankKalis Moderator

    quote:
    The article by Erland is good but i have reservations regarding performance because of xml parsing and all
    You're correct. I haven't tested that myself, but I guess extensive XML parsing is likely to be not very fast.

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de
  6. amitm79 New Member

    An year back i did a comparison between passing an array of values in a string (comma separated) versus passing them as an xml. xml approach was much slower then raw approach because of XML parsing involved.

    Going by xml way is easy to code but definitely not faster.

    Amit

Share This Page