Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Brian Hibbert 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: | Category: cursors
Rating: |  Discuss |   Briefcase | 11,286 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: | Category: untrusted foreign key
Rating: |  Discuss |   Briefcase | 2,385 reads
   Items 1 to 2 of 2