I read this excellent article and have to confess there is one case which I don't fully comprehend.

"BINARY_CHECKSUM fails to detect symmetric changes"

What is a symmetric change?

What other strings could...

This is a classic case for UNPIVOT. If you run these queries with Actual Plan specified, you'll see that it is most efficient plan. Either method has...

HI,

You will need to get more detailed information to get any focused answer to the problem you are seeing. If the tool you are using does not have...

Use the exist() xml datatype method. You can use this in an IF block, or in a where clause... The sample code below profiles usage, and shows that...

Hi,

There are other ways to skin the cat, depending on whether performance is an issue. Using some kind of a an actual table, CTE, or derived table to...

Hi,

I'm not going to write the query for you, but will point you in the direction of good documentation on how to update the values in an xml fragment,...