The query will perform well if written correctly 😉

Plan produced from the following test rig and query:

--

-- Test table

--

DROP TABLE #CourtHearing;

GO

CREATE TABLE #CourtHearing

...

See Using Partitioned Views. Note carefully the need for trusted, enabled CHECK constraints, and the use of UNION ALL - not UNION.

chaitu_ece2000...

Can anyone else hear that high-pitched whining sound in here? 😛 😉 😀

Ionut Hrubaru (3/9/2010)

---

My logic tells me that the Write method is called, nothing is written to the stream, at which point I believe Read method is not called anymore...

Ionut Hrubaru

---

Both failed, but the error did not occur in the Read(), but instead in the Terminate() (divide by 0). I changed the Terminate method so that divide by...

Ionut,

I have ignored point 1 for the moment, since your response was based on an incorrect assumption.

Your original comments in black. My response in blue...

If no rows are aggregated,...

Ionut,

You misread my post. I am saying that your aggregate will throw an exception in the Read method if no rows have been aggregated. This is different from...

Seems safe to me. I can't help but wonder why you need to know, though.

Now you have it! Though, to be fair, that thread is not the best example...not by a long way.

":hehe:" really grates on me now....

My suggestion would have been:

DECLARE @T

TABLE (

RowNumber BIGINT PRIMARY KEY,

...

If the ALTER statement results in a huge number of physical changes (not always the case) which must be logged (always), it can sometimes be faster to bulk export the...

You are receiving that error because that library is not safe to use within the SQL Server hosted environment.

Perform the conversion outside SQL Server.

It's not that I mind people having a go - that's great! It just irks me when the post sounds so authoritative, when it is clearly a pile of...

There are still a few bugs to be worked out in that code: