From my standpoint :

It should not be a programmer's responsibility (alas it sometimes is) to figure out what some quirky piece of code might be doing,

but to express his ideas...

Do not like this question.

There is no economy.

What is actually used is the assignment to @intRND.

tested it, got only one message, so , what ?

Thomas, thanks for article, but, please, what's a Linked Server UI ?

regards Herbert

Hi Greg,

I do not go quite with your conclusions.

If parameterized SQL is used as it is intended, the skeleton of the statement @CMD provided by the application and user input...

well, it HAS an idex, so what ?

This is what I wanted to say with my post.

Thanks, Pawel for saying it.

the caveat with filtered indexes.

if you used a filter of say, col1 is null

then you must state...

Dear Dwain

1. You write

"Because we know that SQL Server ignores NULL values when it constructs an INDEX. "

If I interpret your statement the way it was intended, then,

to my knowledge...

Sorry, you are wrong.

As Memory Optimized Tables are memory resident, the data is Not-Durable upon System Restart/Crash --> this means from A you can deduce B.

As this cannot be deduced...

What good is it to know the evaluation sequence of constraints ?

- may be with the single exception of default constraints, in which special case microsoft would be well commanded...

use option (force order) when selecting from the view

Okbangas, Thanks

I am afraid I was not able to convey the problem I see behind my question: if . as stated by Gail, minimal logging records allcation changes by a minimally...

Enjoyed the article.

Thinking over it I came to this question:

You write: "An operation is said to be minimally-logged if all it logs are the allocation changes."

In the case of a...