I rewrote the SELECT statement I originally posted as it uses a correlated subquery and we all know correlated subqueries are almost always slower than an equivalent query implemented thru...

I rewrote the SELECT statement I originally posted as it uses a correlated subquery and we all know correlated subqueries are almost always slower than an equivalent query implemented thru...

The first thing I can advise is get buy more RAM =)

The second advise is, dont give SQL Server all the memory on your box. Leave some for the OS...

First the short term fix:

A helper view to make things easier

CREATE VIEW HelperView

AS

SELECT

Prefix,

DialedNo,

RateID,

CHARINDEX(REVERSE(Prefix), REVERSE(DialedNo)) AS PrefixPositionFromRight

FROM DSC_Archive a, Rates b

WHERE a.DialedNo LIKE...

In general, specially if learning a new language is acceptable, I recommend using Delphi. Ive used it for years and have had no problems with it, and version 6 is...

i started off being a "hunt and peck" person until i really got into writing code. its was really frustrating at the start because i keep correcting my typos (imagine...

when the feature set of the system involving the database changes you are a developer/DBA...when the feature changes stop and you are only concerned with keeping it work the way...