I couldn't say it better Steward !

Good question. Nice functionallity, I did not know of it existance.

It is easy, except the last one will not be updated because that is not bigger then itself.

infinite loops. My exec of the SP stops already after 32 loops.

I thought so.

But I'm always aware of some unexpected behaviour.

Expect the unexpected

ez1

Yeah Paul you are right.

Bad reading of me.

Where is some more coffee ?

Yeah, Got it.

If you disbale the clusterd index then the insert wouldn't be possible.

But after rebuild you can.

I knewn it.

Default length 1.

So that was the fly in the ointment.

That explanation is loud and clear.

?

I call always use an TOP without an ORDER BY clause.

i.e.

select top 10 object_id from sys.objects

works fine !

Such a learning discussion from such a simple question at first sight.

It looked to easy that TRUNCATE would work at the DELETE permission.

TRUNCATE looks like delete but it is indeed an ALTER command.

A little fly in the ointment

Finally we got native JSON in SQL Server !

I was waiting for that option a long time.

Thanks for pointing at that for me important option.

I thought so. Why else should you use CHECKDB if there is no warning on such a situation ?

A little time ago here in the QOTD there were some questions...