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,979 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,844 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Jl. San Francisco Narogong - Cileungsi; No. 6 & 7, Limus Nunggal, Kec. Cileungsi,...
Menara BCA, Grand Indonesia, Jl. MH Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten Asahan, Sumatera Utara...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers