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,331 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,389 reads
   Items 1 to 2 of 2