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,871 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,643 reads
Blogs
VMworld 2020 – Top 10 Database Sessions (Part 2)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Daily Coping 25 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
VMworld 2020 – Top 10 Database Sessions (Part 1)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Forums
SQLServer Agent not sending dbmail on job completion
Hi Everyone! I have a problem with a SQL Server 2017 with dbmail. I...
Ignore the entire record if a matching record is found
Hello, Kindly guide me with the following code in T-SQL. I need to only...
New Stuff Can Be Scary
Comments posted to this topic are about the item New Stuff Can Be Scary
Ask SSC