This thread has been moved from the QOD forum. Please pay attention and post questions in the appropriate forum.

I understand that. The documentation is the best that I have of this date. I will reword the explanation better. A parallel query, however, doesn't give you multi-threaded execution of...

How about the efficiency of using T-SQL v CLR type functions in SQL Server to solve some problems? It's an interesting debate, but it's one that could probably use some...

There is no formal review board, but if you'd like to be one....

Writing questions that have no typos is hard. If you think it's not, try a few and send...

It most assuredly uses one thread. We discussed this with the developer at TechEd and he pointed out a huge misconception in people thinking that it would execute across multiple...

charindex can help you find the positions of the dash and the =. substring can then extract that part out and you can use that for the comparison.

Look them up...

Dale,

Pls don't cross post. Lots of people scan all the forums, so they'll pick it up in the repl forum.

Steve

You can select this in EM, it's the bottom of the 2nd tab.

sswords, that quote makes the post above rather amusing.

Apologies for this. I have removed the article. If links are broken, that it why.

The query could be the Windows system service, it doesn't have to be inside SQL. The DOM wrapper is around low level code, not necessarily TSQL/TDS stream code. you can...

sure, add a new column in the proper place

select x

, y

, 3 'scalar'

, z

...

I haven't seen that. If you're worried, call MS, sounds like a problem anyway.

I wouldn't be that concerned about corruption. If it is doing cleanup, it should be logged, so...

You need to include the user name. Look up the syntax in BOL.

It should not. I have done this and I think it's a transaction, so it undoes the work done. Or maybe it just stops, can't remember.