We use an Execute Process Task to zip a set of txt files before they are transferred to a MSP. The attached document shows how we have setup the...

Jack Corbett (4/7/2008)

---

Accroding to Wikipedia:

ASP - Active Server Pages

Yes it means that there...

Okay, I'm old and really tired of all the TLA's everyone throws around under the assumtion that we all remember what they are (for example what is ASP, and there...

Sounds like a scheduled job to me. I'd encapsulate the process in a stored proc, and then execute the proc in a scheduled job.

😎

Earlier today my BufferHitCacheRation was down to an average 75 for a good 30 minutes, and the alert never fired.

We did find the solution to our slow PO performance issue;...

I'd actually have to agree that all 4 are correct. I left out 10^24 as I didn't realize that 10^24 = 1000^8. I based my answer on the...

Jack,

you said:

U have it configured to respond via email at 5 minute intervals and it is. I actually modified it to rises about 40 and I just got another....

No, No, really, this would be good:

Are these two queries equivalent?

select

*

from

dbo.MyTable

and

select

*

from

dbo.MyTable

where

...

And just wait until you start having to...

Matt Miller (4/3/2008)

---

Lynn Pettis (4/3/2008)

---

If your table had 10 rows whaere ID = 1 and 10 rows where ID != 1, your query would be thus

select * from MyTable

if you...

Here is some test code I threw together. Take it and play!

create table #MyTable1 (

BeginRange decimal(18,0),

EndRange decimal(18,0),

RangeDescription...

As I said, that is the book I used when I wrote my first SSIS package. I had no experience or training using SSIS prior to that, just my...

Jack,

Okay, I'll have to reverify how I have it setup tomorrow. I'm not at work today due to car problems (darned thing was running fine last night, but this...

A good book I'd recommend is Professional SQL Server 2005 Integration Services published by Wroks. I found that book extremely useful when writing my first SSIS package, and both...

Okay, let's put this query into words. I want all rows where the ID equals 1 AND the ID does not equal...