Where does it say ISO 6801 in the article? I can't find any references to it. I know I had an error a long time ago, but that was changed...

To be able to return results from the query, no you do not need to create an index. If you want the query to perform optimally you should however create...

Using XML to pass in a 'list' of multiple values to use as a search argument is a very bad decision resource wise. There are set based solutions that can...

Note that decisions to use cursors, temp tables and table variables should not only be based on the duration required to run a single process using them. The real cost...

You have no real way of knowing what the maximum required size is. What if I come in one day, start a transaction and then just continue working all day...

Actually, there are no "non-logged" operations in SQL Server. There are operations, such as BULK INSERT and TRUNCATE, that are minimally logged. But all operations are always logged, meaning any...

I am sure there exists similar ones, but I have no idea how good they are or what features they have. If you want to I am sure the admins...

The Database project type is only available in Professional and higher SKUs. For an alternative (I always use this, even in Professional) check out Niels Berglund's SQLCLRProject addin for...

The SQLCLR team's blog has a good post showing this:

http://blogs.msdn.com/sqlclr/archive/2005/07/25/Vineet.aspx

Is D:\myclient.exe a path that exists on the server, i.e. not your client computer?

You need to specify the full path to myprog.exe, or have it in the path environment variable (for the account SQL Server is running under).

I am just not so sure that the DBMS should include all the behavior of a type. A mutator operator such as the one you described might be necessary to...

Sure, using a SQLCLR object (a stored procedure or function implemented in a .NET language) you can access webservices. The assembly containing the object needs to be registered with EXTERNAL_ACCESS...

I do not use EM so I don't really know about that. From the message it sounds as though he did not own the table.

Naturally, no. What I am saying is that I do not like adding more operations that are only used for specific types for manipulating data, when the existing set of...