ambiguity = "in a TRY block"

what does "in"...

After copy and pasting the plan I spent a couple of minutes trying to figure out where the [Sad] reference came from ...

LOL I guess 🙁 becomes [Sad]

here are some...

I am bored of this topic now

But still expect anybody saying that BOL is *not* ambiguous to provide a quote to prove it

(I cannot provide a quote to prove that...

use tablockx

create index on temp table

update statistics before update

check index condition before and after update

adjust fillfactor, padindex accordingly

ensure logs are on separate drives to data

ensure data and log files not...

You are aware that SQL doesn't use binary trees for indexes? Depending on the index, the 'middle' value is not necessarily going to be in the root page of the...

His post did not add anything to the discussion - it was therefore light trolling

forum dwellers do tend to get upset when the status quo / comfort zone of "guru"...

I am saying that IF there is an index on the column it should be possible...

parsing TSQL fully is hard

but if you limit yourself to the section up to the first (uncommented, unquoted) AS in DDL statements for P, TR, FN, IF, TF modules

it is...

here is my attempt at a deadlock loop with try catch

there are two << which are critical to stop problems related to unwanted resumptive error handling

sorry if I am stating...

this table shows whether errors are handled resumptively or not

remember that when calling execute on a connection (eg. outside of a procedure) the caller is "no try"

CURRENT SITUATION:

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

caller ...

There is also an inconsistency when handling certain errors

BOL states:

A transaction enters an uncommittable state inside a TRY block when an error occurs that would otherwise have ended the transaction....

for example, in this code fragment from the Using TRY ... CATCH page in BOL

BEGIN CATCH

-- Check error number.

-- If deadlock victim error,

-- then reduce retry count

-- for next...

I know perfectly well how SQL Server works

I am talking about the ability of the optimizer to use a binary search algorithm to quickly find the minimum and maximum values

of...

please read and understand the post before you reply

If you don't mind, I'll just go ahead and disagree with you on all those points. 😉 It all works exactly as I expect it to work according to...