Snapshot isolation is not serializable. Although Oracle had (and has ?) a serializable isolation level, according to the ISO standard it was (is) not serializable. See :

November 14, 2019 at 2:13 pm

#3697655

Hello, I am from a different culture, so my view might not be applicable.

A Junior, might expect some guidance from a Senior within the workforce. If the Junior encounters a...

If the information of the Geometry flat euclidean coordinate system is of a limited area this information can be converted fairly accurate. (The curvature of the earth does not play...

In General:

Keep the original data and add the modifications in another column. (Sequence hold the sequence number, status on Hold means that the sequence should only processed after sequence numbers...

--
-- Money is exact to 4 decimal places.
-- 

Declare @geld money = 12.3456
SELECT @geld

SET @geld = @geld*0.1
SELECT @geld

The mony type is  exact to 4 decimal places, it...

Additional:

Long time ago with did intensive research into one specific deadlock. On line and during conferences I was often told that this could not occur within SQL-server. But with did...

• This reply was modified 5 years, 2 months ago by  ben.brugman.

I was thinking to separate the transactions adding BEGIN TRANSACTION and COMMIT TRANSACTION on both of the update statements. Will it help in avoiding the deadlock? Can anyone help me in suggesting most efficient...

--
-- Float compare.
-- Compare two numbers which are 'almost' equal.
--
DECLARE @A      FLOAT = 1./3
DECLARE @B      FLOAT =...

The hope was for a simple solution, without the FOR XML construction. Also I would like to avoid the CTE with a 'recursion' construction. Only 'a list of a few...

Hello jcelko212 32090 and others,

You want to be using some tool other than SQL for this.

Luckily it's me who determines what I want, it's perfectly ok that you want to...

• This reply was modified 5 years, 3 months ago by  ben.brugman.

The usefull function :

DelimitedSplit8K

Has the advantage of numbered items above the STRING_SPLIT function. The DelimitedSplit8k gives the item number and the item value, so you have them ordered.  Also it...

Using an auxilary date table can solve a huge number of date related questions.

Questions like:

What is the number of days between two days?

What is the number of working days between...

• This reply was modified 5 years, 5 months ago by  ben.brugman. Reason: [Quarter] was written with a Q only which is a formatting command

See the Thread :

https://www.sqlservercentral.com/forums/topic/sp_generate_inserts

Sp_generate_inserts can still be found. It does generate inserts scripts and has a lot of options. It can be called from a script or a stored...

When cleaning data, one of the first things to do is have a 'model' in your head how the data is working. A logical model which data is present and...

@Taps, simpler and therefore better.

Ben