Les Cardwell (3/15/2010)

---

In spite of the criticism, it was still a simple example of minimal denormalization to achieve an end result rather than a full-on explosion of wide rows to...

Les Cardwell (3/15/2010)

---

In spite of the criticism, it was still a simple example of minimal denormalization to achieve an end result rather than a full-on explosion of wide rows to...

Yes, in SQL Server 2008 it is missing the data type. Should be:

DECLARE @selectDate datetime = getdate()...

When a process is sleeping it simply means this:

Sleeping - Currently running no requests

I think you are looking for a solution for a problem that doesn't exist.

bitbucket-25253 (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Grant Fritchey (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Grant Fritchey (3/15/2010)

---

GSquared (3/15/2010)

---

What year? (My birthday was yesterday, so I'm curious as...

Ittech03 (3/15/2010)

---

Select

client_id as Client,

ApplicantFullName as ClientName,

CounselorName as Counselor,

lastapptdatetime,

tdate,

TUDCounselor,

TDDate,

FUD1,

FUD2,

FUD3,

FUD11,

FUD21,

FUD31

From PDT_Counselor_CO_View

where coalesce (complete,0) <>1 or coalesce(tud,0) <> 1

and tdate >= dateadd(dd, datediff(dd, 0, getdate()) - 30, 0)

Order by client_id desc

This is...

Is the seek on the table or on the index? If you created the requested index on Col4 and included the columns Col1, Col2, Col3 it should be doing...

For example:

SELECT

oh.*

FROM

...

Yes, this will work.

Different subject, like your tag line.

We found an inexpensive sslftp solution that we incorporated using an EXECUTE PROCESS TASK to handle our secure FTP task. Only requirement, we have to maintain that piece of...

GilaMonster (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Grant Fritchey (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Grant Fritchey (3/15/2010)

---

GSquared (3/15/2010)

---

What year? (My birthday was yesterday, so I'm curious as...

Check out this article[/url]. You may also want to read the discussion that followed.

Grant Fritchey (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Grant Fritchey (3/15/2010)

---

GSquared (3/15/2010)

---

What year? (My birthday was yesterday, so I'm curious as to what the...

Grant Fritchey (3/15/2010)

---

GSquared (3/15/2010)

---

What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.)...