Sounds like Steve is having a journey from hell , not much fun

simply add one month , then minus one day.

I like this one..

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

10,000...

This is a classic example of why you should use the correct datatype.

Between does work on strings but you are applying different rules just because you have string that looks...

Can you post execution plans from both systems so that we can compare ?

I blogged about this issue a little while back

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2010/01/22/microsoft-follow-best-practices.aspx

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2010/01/25/microsoft-follow-best-practices-part-2.aspx

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2010/01/27/cleaning-up-sys-dm-exec-cached-plans.aspx

Microsoft have closed the connect item as fixed next release (though if that means 2008 r2 i dont know)

This also came up...

Not quite as bad as "I really need a Fag" , as i once loudly announced in...

What !!!!

use a udf ? , (select null) will perform better 😉 😀

Ive run a quick test and select top(10) from a table of 54.3 million rows,

the checksum version runs in 23.9 seconds where as the plain newid runs in 22.9.

So in...

Eralper (3/11/2010)

---

I have seen on some web sites suggesting to use ORDER BY CHECKSUM(NEWID()) instead of using only NEWID() function.

I think it affects the seed of the NewId function to...

martin.edward (3/10/2010)

---

Dear Experts ,

I have the following string

SBR9D28.0178

The fourth character from the left stands for year i.e. 2009

The fifth character from the left stands for the month i.e. April

I would...

Interesting , ill look at the unpivot.

The competition has closed long ago ,...

Peter Brinkhaus (3/10/2010)

---

I'm not sure why but you have to enlarge the numbers table to get rid of the error. After that the query runs in 82 seconds on my...

This can be achieved by using dynamic sql , but i would only do this as a last resort , if this cannot be done at the front end.

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

You could use pivot ,

but i would prefer to sum a condition.

So something like this ?

select username,

sum(case when Status = 1 then 1...