And does the test query return exactly the same results as the production query?

Kev

George,

sometimes a good indication of having a bad plan cached is that the query miraculously works fine after a reboot (or a DBCC FREEPROCCACHE), but I'm guessing from your earlier...

George,

it does sound like there could be execution plan issues, as I guess on your machine you have a fairly clean procedure cache, whilst the 'live' server has a relatively...

I knew you'd pick this one up Shaun!

What a great tip!

I been having to open multiple windows for months now - but no longer!

Just shows how often you miss what is right under your nose

Kev

Steve - are points awarded for submitting a QoTD?

I think a points awarding system based on the rating of an article and/or number of reads would be useful - I...

I posed a similar question a while back....http://www.sqlservercentral.com/Forums/FindPost459604.aspx

Kev

I guess your issue is with SQL Mail?

Technically yes...

Also noticed that these links take you to SQL 2008 pages (I guess the default links always refer to the latest version). You can follow the links at the...

That's true!

I guess these should have been used:

Database Mail: http://msdn.microsoft.com/en-us/library/ms175887(SQL.90).aspx

SQL mail: http://msdn.microsoft.com/en-us/library/ms177418(SQL.90).aspx

WayneS (8/19/2008)

---

I thought that Database Mail replaced SQL...

Also in addition to the links provided, here's a link to a more complete list of disabled features

http://msdn.microsoft.com/en-us/library/ms183753(SQL.90).aspx

Kev

I too have used this technique for many years as a way of quickly exposing the outputs of SPs for reporting - usually reporting that sits outside of the more...

not if Chandru needs the month name to be the full name - that's the issue with the solution I posted.

Kev

there is no one style that would do that, but you could use style 107 together with datename()

select datename(dw,@date) + ', ' + convert(varchar, @date, 107)

If you really need the...

Sorry - should have posted an update long ago........

No, the iisreset had no effect whatsoever.

In the end we actually edited the links by exporting the data from Sharepoint into an...