Also be seriously aware that the return datatype for PARSENAME is NCHAR.  It you're saving the output in a table somewhere, it will save trailing spaces even if the target...

I try to test as if it's real life.  Yes, I clear cache at the start of a test because it's important to know what will happen and how long...

Yes.  Almost identical.

I also just found out this also affects the DATE data-type when used in a similar fashion in the WHERE clause.  That means that all those...

Heh... I hate people that send me .gz files and .rar files and all the rest.  Just send me a good ol' fashion .zip file that works fine just about...

Ok... first, there is no need for an explicit transaction.  Having an explicit transaction for the two examples is a classic setup on a table for a pot wad of...