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...

Just to add to the advice - I would advise against SELECT * unless it is absolutely necessary. The reason being if the source metadata changes (column added or...

I have to give Steve a huge amount of credit for my success... he's kept this site going and he encouraged me to write articles.  This site was also a...

We had similar...

Do you have a link on that subject?

Heh... all that and it still left a temporal BETWEEN instead of using the more correct and bullet proof "Closed/Open" comparison method...

... 
  WHERE soh.OrderDate >=...