yes, using another approach is a valid option, i need, at least, to reduce collisions.

CELKO (11/30/2016)

---

>> I need a query to find out all orphans over a hierarchical table <<

``

I never heard this term before, and I wrote the standards. I think you are...

Eric M Russell (6/13/2016)

---

DELETE + INSERT will probably result in more reads, writes, page fragmentation, and transaction logging, so for that reason I'd suggest an UPDATE | INSERT. The less...

GilaMonster (6/13/2016)

---

Not atomic,...

the goal is to update text valus if a record with that...

delete insert are inside one transaction, so i think it would be atomic operation.

default level is read committed so it would be impossible another transacion insert and commmit before...

no, the data comes from a newspaper's supplement , first page is variable.

yes it's a newspaper, there's only one page for one day.

Kristen-173977 (9/23/2015)

---

fabriziodb (9/23/2015)

---

delete insert is 2 operation, i think other way is most expensive:

1) insert the rows from parameter that are not in the table

2) update the rows that are...

isolation level is irrilevant also in delete operation? i thought before deleting it need a select to identify the records to delete.

usally the stored procedure take from 1to 5 sec to execute, but apparentuly with no reason some time the execution time grows till 1 minute.

delete insert is 2 operation, i...

yes it does, thanks

i did it

declare @temp table (ID int)

declare @i int = 1

while(@i<1000) begin

insert into @temp values (@i)

set @i=@i+1

end

Select cast(A.ID as varchar) + ' - ' + cast(B.ID as varchar) From...

thanks, get spaghetti code 🙂