Yup, another inaccurate question... I guess I didn't choose the "favorite" answer, even though it was correct

The assembly is loaded into the database. The DLL is no longer used -- and can even be deleted.

You are correct, there can be many issues, and it is...

Not a whole lot. I think 5% is a very accurate figure for the current implementation. However, if MS changes a few things about the way UDTs and...

COM objects? Please, don't do that if you can avoid it. COM is unmanaged and unsafe.

Being able to call into .NET assemblies (and the .NET BCL), on the...

StringBuilder is a great example. So is pretty much any math operation. Recently, I've been playing with the following method, which mathematically reverses an integer:

-----------------------------------------------------------

[SqlFunction]

...

Re-read the question. There is no ORDER BY clause

I was referring to the fact that SQL Server does return an ordered data stream when you run SELECT * from a table -- it's ordered by virtue of the...

No, just that a table is unordered. And is, therefore, not a list at all.

If we're talking SQL Server, then yes, we can bring in rowsets (or, perhaps, "tabular data streams"), and we can call them lists. One property inherent to lists is...

Hi Paul,

Works fine for me. Are you running the latest version of Firefox?

Also, I recommend getting the Copy as Plain Text plugin for this kind of thing. Firefox,...

Steve,

Define 'list', in your own words. No Merriam-Webster allowed. I'm curious how your definition tallies with my understanding of what a table is.

Hmmm, I guess it's pedantic to mention this, but this doesn't return a list. It returns a table.

Hmm, apparently I read the answer wrong the first time.

Okay, Steve, I think we need some points back here

Doesn't that mean that the answer (Yes -- you can report from a mirror) was right?

Joshua,

By "database view," I assume you mean "snapshot"?

It shouldn't matter when it's created -- off hours or not -- creation of a snapshot does not move any physical data, and...