Thanks! I'm to old for this 😉

It returns "that" when I test on SQL Server 2008, but I thought it should return "this"...

Has this changed in later SQL versions? I am pretty sure I've learned that...

Ok, bad reading...

SSMS status bar NOT = Query window status bar.

I'm not native english speaking/reading so maybe I'm misunderstanding something? Like True=False??

Well, got it wrong to. Not that it matters, but this is more a "proofreading" question than anything else. I haven't submitted any QOD myself, so i shouldn't complain...

But did...

I have to get my eyes checked! columns != rows...

Hmmm, I get "Clustered Index Scan" as both PhysicalOp and LogicalOp in

SQL 2008 with Auto Statistics "false".

With Auto Statistics "true" I get one inner join.

I have to check why Auto...

Hugo Kornelis (9/4/2009)

elbedata (9/4/2009)

You mean, when changing the datatype from fixed length to varying length?

I'd hesitate to describe an unasked for removal of trailing spaces "smart". There are builtin functions...

You mean, when changing the datatype from fixed length to varying length?

I'd hesitate to describe an unasked for removal of trailing spaces "smart". There are builtin functions to remove them...

I thought SQL Server was "smart enough" to remove the trailing spaces. You always learn something new here...:-)

Maybe the second alternative should have been "S"? "T" really doesn't make any sense at all. It really doesn't matter though, it's wrong anyway 🙂

He, He, Didn't think about *.ldf as a "database" extension.

Sometimes the QOD wording could be better... 😛