Performance Improvement for Cursors in Stored Procedures
Exploring some differences between using cursors, local fast forward cursors and using set logic.
2016-11-11 (first published: 2015-02-03)
14,895 reads
Brian Hibbert
Untrusted Foreign Keys with NOT FOR REPLICATION Option on the Key
My Foreign Keys are STILL untrusted after the double CHECK. Here's how you can fix this issue.
2015-01-19
2,824 reads
Blogs
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to...
Inspector V2.6 now available
As always the code can be found here in our github repoWe updated our...
Data Mesh: Centralized ownership vs decentralized ownership
By James-Serra
I have done a ton of research lately on Data Mesh (see the excellent...
Forums
Do You Have ALL the YAML?
Comments posted to this topic are about the item Do You Have ALL the...
Why Power Query as an Activity in Azure Data Factory and SSIS?
Comments posted to this topic are about the item Why Power Query as an...
Azure Blob Store Redundancy
Comments posted to this topic are about the item Azure Blob Store Redundancy
Ask SSC