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.
2007-12-28 (first published: 2006-12-07)
47,966 reads
Writing complex queries can be a little tricky, especially when you get into outer joins and inequalities. New author Amin Sobati takes a look at a tricky situation with the "Not Equal To" operator and shows how you can avoid inaccurate results.
2006-08-23
14,843 reads
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Comments posted to this topic are about the item Celebrating Tomorrow
Comments posted to this topic are about the item SQL Art: I Made a...
I am using ssrs in visual studio 2022, I work on a report, there...
Which of these is more appropriate for tomorrow?
See possible answers