Both HA and not HA

I can not comment on his decision.

Anyway, it will be intresting to see in what circumstances it happends. This way we can hope it will get fixed.

In my case is...

My DBA (I'm developer) did not agree with the flag, said it will impact performance, sql2008 identity is more resource intensive.

I implemented you first solution with reseed max value. It...

I have the same problem with SQL2012 (11.0.5058.0) on many tables.

I checked for reseed and set identity_insert. It's not the case.

If there is a unique constraint insert fails. It not...

I got 3.33 on all tests

1) win xp, 32bit, SQL Server 2008 Developer Edition

2) win xp, 32bit, sql server 2005 Express Edition

3) SQL Server 2005 Developer Edition (64-bit)

4) SQL Server...

If you get 15.6521 it does not mean that this is the precision of getdate()!

Why do you think that @Time and @TimeEnd have succesiv values?

The conclusion, in my opinion, is...

If you cause a page split. But if not? It is still false as a general statement.

I agree that is not wrong, but is false as a general statement. It is out of context.

It is true where you create/rebuilt an index, but false when you insert/update/delete...

This is wrong:

"A clustered index physically rearanges data on disk."

because it is out of context

and because: "Once created, a clustered index is maintained logically rather than physically."

This is false:

A clustered index physically rearanges data on disk.