A couple of things to check?

Do you have autogrow on?

It is possible that your database files needed to grow.

Another possibility would be the occurence of page splits.

Is the number of...

Thanks John,

works like a charm.

I also took a look at the collation coercion rules in BOL, to see wich other functions are affected.

Just to keep it in mind for the...

Well,

this proves I have to sleep sometimes.

My mistake Kelvin

You are right Kelvin, but then again...

the weekday will be correct only when you use sunday as the first day of the week

Hello all,

the day of the week you get of course depends on your configuration.

Where I work it is common to have monday as the first day of the week, so to...