An interesting observation on Yukon SQL, sometimes an update statement’s performance is quite slow.  For example, let’s present a SQL table with 3+ million rows with a LogAuditID column , int data type, value of 0 for all columns; the table contains a nonclustered index not on the LogAuditID column.  If I wanted to update all of the rows within this table with a value of 1, running the following statement:   update [table] set LogAuditID = 1   is quite slow. On both single proc and multi-proc boxes, this one simple statement can take a long time to run.   But, if you re-write…