Matt Miller (10/26/2007)

---

Results:

raw sort 52956

convert sort 89013

and now with an index

raw sort ...

Oh really?

Then I assume that what was 'desired' was something else than what was written?

You're actually saying that the below example is 'incorrect', or 'undesired', or simply plain 'wrong'..?

[font="Courier New"]declare...

Because semantics *is* important, and this is a good example of why.

SQL is language where we construct questions, and as you ask, thou shalt be answered.

So, here we ask for...

Jeff Moden (10/26/2007)

---

No, not crazy... both of the following...

Matt, do you have any example that shows such abysmal difference?

Tried a little, and sure, there is a piece of overhead between

ORDER BY datecolumn

and

ORDER BY CONVERT(CHAR(8), datecolumn, 112)

for example..

But far...

Nah, probably just cuz it's Friday 😀

It's probably because the WITH INDEX trick doesn't really work.

Before anyone blows a fuse, by 'not really work' I mean 'not supported', 'isn't reliable', 'cannot be guranteed 100% to always...

You can still order by that as well..

Or are you talking about something else, Greg?

J M - the place in BOL you're looking for is under 'CONVERT'

There you'll find...

Well, first of all you need to have a genuine interest in 'dba:ing' (whatever that is) 😉

As with everything else, you want to learn as much as possible about how...

Sergiy (10/25/2007)

---

Are you sure Tom Carr is an author?

Would you mind to look couple of pages back?

It's just almost exact copy of my script. "+6" is replaced with "-1" -...

Have to revise my previous ramblings on insert order and identity above, apologies for that.

(though it's somewhat a sidetrack it deserves to be correct)

Contrary to what I wrote before, if...

Then you need to upgrade your current version.

-- quote BOL --

Requirements

Log shipping has the following requirements:

SQL Server 2005 Standard Edition, SQL Server 2005 Workgroup Edition, or SQL Server 2005 Enterprise...

Ah, just small details that tends to get lost in the overall excitement...

Like first, when performance was measured by just execting something and as I assumed, also returning the results....

Dunno why it didn't work..

Though I agree that the output (with 'password' promt) looks suspicious.

Couldn't replicate it. Worked both on 2k and 2.5k, no problems at all.

The one difference perhaps,...

Oh yes, using DATEDIFF that way will work, as long as:

the 2nd parameter's...