Thank you Sir. Will definitely go and check the documentation.

Thank you ! Its has pretty much everything.

Thanks for the detailed explanation Sir. Thanks a ton.

Thanks Andrew.. We don't have waits for a good run but definitely we can collect waits using sp_whoisactive and review the output.

Anyone ?

Thanks everyone for the replied. Sorry, looks like everyone is misunderstood my question. My question is,
"whether it creates two ring buffers with each buffer 500 MB size or else...

Thanks Grant & Gail. Learnt something new today 🙂

Thank you very much Sir.

Thanks a ton Tom. One last question, what are the potential drawbacks of having separate tables for each action type?

Even I heard some issues with MERGE when dealing with large sets of data w.r.t lock escalations and all..

Suppose I had to write the logic using plain tsql,...

Any thoughts pl

select PropertyType,[DisplayId],[Title] 
from   (select  ROW_NUMBER() over (partition by PropertyType,PropertyName order by PropertyValue) as rn,
PropertyType,
PropertyName,
PropertyValue 
from test) as src