TheSQLGuru (12/8/2007)

---

Two points you are missing in the performance equation Colin. With a SAN it isn't just about the disk I/O capability. SANs usually come with large (sometimes...

The error you're getting assumes that you're trying to publish to a local IIS installation. In order to do that you'd need SSRS installed on that machine. You...

Try this on:

select a.*

update a

set Repflag='X'

from volume a

where exists (

select *

from volume b

where

b.id=a.id

and b.perEndDate=dateadd(day,-1,dateadd(month,-1,dateadd(day,1,a.perenddate)))

and a.AchieveLev<b.achieveLev)

GilaMonster (12/8/2007)

---

An index on a column does not guarantee that data will be returned in that order. Unless an order by is specified, you cannot be sure that the data...

You can do it a few ways. Personally I'm a fan of using .NET regular expressions to do just that, but that involves allowing CLR integration, which some are...

The one that doesn't say anything of the physical implementation is the Mathematical model. While the...

Ramesh (12/6/2007)

---

RichardB (12/6/2007)

---

It's probably STILL trying to commit....LOL

Steve Jones - Editor (9/15/2003)

---

I did find that Groupwise has a MAPI interface, but not sure if this will work.

Upgrading a server tomorrow and will try some integration, but since...

If...

Ramesh (12/7/2007)

---

Before 2K5, many a times, we used the following methodology in our financial applications to get the running count for records. People do argued on this stating that...

Oops - i guess I missed that one...sorry!

Stephanie J Brown (12/7/2007)

---

Wow, I hate to break the trend, but despite my very good life (and the new CTO who is making things MUCH better at work :D), there...

Christian Buettner (12/7/2007)

---

Hi Jeff, Chirag,

I am not sure if I misunderstood something, but the SQL Statement does NOT utilize a "triangular join":

Select orderid,orderdate,productid

from orders O INNER JOIN orderdetails OD

On O.orderid...

A seek means that you are looking for specific value(s) and the index provides you with the best way to do it. This also applies to specific ranges of...

I don't know if we can breach the 90 second barrier you have, but using temp tables (expecially indexed ones) to pre process some of this should pretty much guarantee...