AMEN!

Yes, you are right, 99% of the time, set-based or in-memory pipeline is the way to go. However, for performance reasons, sometimes the counter-intuitive way is the way to go....

As in being inneficient, yes it is, but that depend on your case/purpose.

If you however only need to apply that sp to 100 rows of a DF of 20...

John,

Is the output of the SP what is the problem, say that the procedure returns two rows... like lastId int, nextId int.

That is what I am...

My fault. I meant to say "Execute OleDb Command". It is used frequently for update statements on an individual row basis.

Francisco.

I guess I am out of luck then? :crying:

Hehehe, I never meant to say *all* scenarios, but yes, table...

Yes, this is the good old and tiring issue in Sqlserver. In oracle, partitions are just faster in all scenarios, however, this is not the case with sqlserver. It does...

Well,...

Hi,

Under my indication, a new bug was opened in Microsoft connect back then. They acknowledged the z-order problem in the rendering and scheduled it to be...

For the record, just in case anyone is looking for the same info:

There is a BUG in SQL Server 2005. It is documented that setting the packet size above 16KB...

george sibbald-364359 (10/28/2009)

---

there is a configuration option in SQL for network packet size, this has a maximum of 32K.

change this at your peril. I did once and it broke part...

Lowell (10/28/2009)

---

I think packet size is a TCP/IP limitation; it's not really related to the program that sends the data(ie Word, SQL 2005, MYSQL,etc)

For Ethernet LAN/WAN, max packet size is...

Absolutely nobody has a clue on this and/or has never happened to anyone?

Thanks in advance.