SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Amin Sobati

SQLServerCentral.com profile

   Items 1 to 2 of 2   

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.   Read more...
By Amin Sobati 2007/12/28 (first published: 2006/12/07) | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 44,938 reads

The Pitfall of "Not Equal To"

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.   Read more...
By Amin Sobati 2006/08/23 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 14,543 reads
   Items 1 to 2 of 2