Watch out when using @@IDENTITY and SCOPE_IDENTITY() in your applications. Below is a quote from a Microsoft SQL Server engineer.
whenever a parallel query plan is generated
@@IDENTITYandSCOPE_IDENTITY()are not being updated consistently and can’t be relied upon.
You can find more about the bug and workarounds at the SQL Server bug report.
UPDATE 28MAR2009: Pinal Dave has a more detailed blog post about the bug with workaround.
IP version 6 has not become the de facto standard yet, even though we are close to have exhausted all IPv4 addresses. I set out to learn more about IPv6 and ...
Not a week goes by without new security vulnerabilities. The Wi-Fi vulnerability KRACK and the security chip vulnerability ROCA are some of the more severe o...
Secure Boot is essential for securing your computer. This guide show how to enable it, so malicious software cannot infect your computer before startup of th...
Tutorial to create a Windows Container with a .NET application using Docker layers to compose upon existing Docker images
Comments