SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Brian Hibbert

SQLServerCentral.com profile

   Items 1 to 2 of 2   

Performance Improvement for Cursors in Stored Procedures

Exploring some differences between using cursors, local fast forward cursors and using set logic.  Read more...
By Brian Hibbert 2016/11/11 (first published: 2015/02/03) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 11,376 reads

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.  Read more...
By Brian Hibbert 2015/01/19 | Source: SQLServerCentral.com | Category: untrusted foreign key
Rating: |  Discuss |   Briefcase | 2,406 reads
   Items 1 to 2 of 2