I've tested this query against sample DB and against my current search query:

select distinct object_name(sc.id) [name]

from syscomments sc

Where PatIndex('%<text, varchar(200),>%' , text ) >...

Yes. I ran query 3 times with different language settings. Result are rendered against your test data.

I think, that my test environment is far weaker;).

Forgive me, but I will no...

Different method

DECLARE @Bitbucket CHAR(10);

SET STATISTICS TIME ON;

SELECT @Bitbucket = substring(convert(varchar(100), SomeDate,13) , 4,8)

FROM...