Great article. I came here to understand how fragmentation occurs in a SQL Server and this article by far is the most detailed article I have read on the structure...

It appears to me that you can be hit with   performance issues of a different nature if you are not careful with your design while incorporating AlwaysEncrypted. Eg. Let us...

At the very end of the article there is a statement " If your SAN offers encryption at rest within the SAN, that will likely be much faster than a client-side...

It is too long a story. The 'need' is to not touch the application code/and or stored procedure doing the inserts. So it is left to the triggers to...

Thanks. I had already started doing some tests in this direction and you recommending the use of INSTEAD OF triggers as a solution gives some assurance to...

Hi Hugo/Jeff

Thank you for sharing your thoughts on this. I really appreciate you guys going above & beyond trying to understand the problem and providing a resolution....

Hi Jeff

Regarding using Hugo Cornelis mechansin "... then at least add the failsafe trick that is suggested earlier in this discussion so that you'll get an error rather than incorrect...

Hi Jeff,

Thank you for your response. I do understand that I shouldn't be using this method if I am using MS SQL2012. The issue here is that my customer environment...

Hi Jeff

Great article. Came across it when searching for ways to make updates proceed in a sequential order, similar to the running total problem. I have an observation...