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)
13,549 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,603 reads
Blogs
Daily Coping 13 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Last Week Reading (2020-07-12)
By Kamil
Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....
Daily Coping 10 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Creating a Dimension with no Primary Key
Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and...
Code signing a dll with certificate for use in SQL Server 2016
I have a dll that will perform some webservice calls function. in order to...
Find whether a clustered index is actually unique
Hi I have a table that has a clustered index on it The...
Ask SSC