This can be done by creating database level triggers and can seriously be enhanced in capturing not only what changed when but by who from where.

I can't offer the code...

i have a database with 400 stored porcedure , i need to optimise it , i found that tables are not having command index also.

like joins where ,group by...

Great question.  Proof that extra features always come at a price. 😀

It also means more page splits than normal due to "ExpAnsive" UPDATEs because of the typical extra 4 bytes...

Btw, I disagree with those who suggest to always specify the windowing range.  The default is ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.  Why repeat it?  The best part...

I know this is an old post but thought I'd add a little constructive feedback as to why folks may have graded it low.

If used for 100 rows, the data...

Nice article.

TBH though, there are a lot of things listed as "disadvantages" for these 3 datatypes that I also wish you couldn't do with the newer MAX datatypes.  I also...

I doubt that anybody (besides some old, long retired boomer nerds that implented it decades ago) are using COLUMNS_UPDATED(), particularly since

• you could write  UPDATE(col1) OR UPDATE(col2) OR UPDATE(col3)...

The question specifically states "I want to determine if both the CustomerContactFirstName and CustomerContactLastName fields are changed, but no others. "

That means that the first answer cannot be correct...

Just to be sure...

Anyone with "db_owner" privs on a database can see, use, and manipulate any and all objects in the database, regardless of who owns the individual objects because...

The number of 30102777 is NOT a row count... it's a PAGE COUNT (1 logic read = 1 8KB page)  If you divide that number by 128 (the number of...

Although Ola's code has been branded as the "Gold Standard" by good people like Paul Randal, I won't use his code for index maintenance because it measures the wrong things...

COLUMNS_UPDATED() will tell you which columns had an update attempted but it will not tell you if a value actually changed.

Also, I'm in favor of the clarity of  IF UPDATED(CreditLimit)...

It returned some headers so none of the answers is actually correct.

I have Norton Utilities and Global Protect running... one of them didn't...

What on Earth are they thinking?

Lordy...