SQL Server Updates behavior

Recently a client asked me: “We want to place all the fields of the table in the SET clause of an UPDATE, no matter if the values are changed or not. How does it impact the I/O? Does SQL Server update every field, even if the old value matches the new one? What about indexes?”…

0

How to Disable Always Encrypted Feature in SQL Server 2016.

Hello, my name is Stefano Altamura and I’m an Italian PFE dedicated to SQL Server and Data Insights. In my first post I want to talk about an approach that I often use to better understand how new features works. A wonderful new feature in SQL Server 2016 is Always Encrypted. You can find lots…

0