Amin Sobati

Row-By-Row Processing Without Cursor

If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this.

2.88 (93)

2007-12-28 (first published: )

45,024 reads

Blogs

Containers: Working With Volumes

By

In the previous two posts on containers I showed how use Docker commands to...

Speaking at PASS Summit 2019

By

I am delighted to announce that I have been selected to speak at the...

High Security Prices–Always Encrypted 2019 needs Datacenter Edition

By

I was recently doing some work on Always Encrypted in SQL Server 2019 and...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Response to Bloor article on SQL Provision

By gbritton1

I found the article https://www.sqlservercentral.com/articles/bloor-scores-sql-provision-4-5-out-of-5-for-test-data-provisioning Interesting if a little shallow.  It would be more...

Row Level Security - Enabled but not Filtering

By dempstererin

...this is a 2nd attempt to post, as I can't seem to find the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers