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)
16,635 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
3,412 reads
Blogs
T-SQL Tuesday #178–A Recent Technical Problem
By Steve Jones
This month we have a good invitation from Deepthi Goguri, where she asks us...
Redgate Clone Graduating Images
By Steve Jones
I wanted my own custom image in our internal Redgate Clone cluster, so I...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
Capture long transact query using SQL Server performance condition alert feature
I created a SQL Alert trying to capture long query transaction under the SQL...
Question of the Day
Adding Features During a SQL Server 2022 Upgrade
I have a SQL Server 2016 SP3 instance that I want to upgrade to SQL Server 2022. I don't have replication installed, but I want to enable this on SQL Server 2022. Can I add replication during the in-place upgrade?
See possible answers