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...

Jack,

I tried creating an Alert, but it doesn't seem to fire. Is there something else that needs to be done that I may be missing? I was sure...

Well, that last bit of info may be a bit old, but it was valid at my last employer. The reports were run on an automated schedule then dumped...

I also think it depends on the type of reports created as well. If the reports used by users are static, you may not need to count those users....

WILLIAM MITCHELL (4/2/2008)

---

A rule of thumb when writing your resume is to include only the last 10 years of work experience. I would expect that a degree that is more...