Viewing 15 posts - 24,916 through 24,930 (of 26,486 total)
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;...
April 4, 2008 at 1:42 pm
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...
April 4, 2008 at 1:06 pm
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....
April 4, 2008 at 12:55 pm
No, No, really, this would be good:
Are these two queries equivalent?
select
*
from
dbo.MyTable
and
select
*
from
dbo.MyTable
where
...
April 3, 2008 at 2:03 pm
GSquared (4/3/2008)
Don't feel stupid. The computer version of "and/or" throws a lot of people. Takes a while to get used to.
And just wait until you start having to...
April 3, 2008 at 1:50 pm
Matt Miller (4/3/2008)
Lynn Pettis (4/3/2008)
select * from MyTable
if you...
April 3, 2008 at 1:46 pm
Here is some test code I threw together. Take it and play!
create table #MyTable1 (
BeginRange decimal(18,0),
EndRange decimal(18,0),
RangeDescription...
April 3, 2008 at 1:26 pm
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...
April 3, 2008 at 1:25 pm
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...
April 3, 2008 at 1:05 pm
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...
April 3, 2008 at 1:02 pm
where ID = 1 and ID != 1
Okay, let's put this query into words. I want all rows where the ID equals 1 AND the ID does not equal...
April 3, 2008 at 12:55 pm
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...
April 3, 2008 at 10:48 am
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...
April 3, 2008 at 10:47 am
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....
April 3, 2008 at 10:13 am
WILLIAM MITCHELL (4/2/2008)
April 2, 2008 at 10:28 pm
Viewing 15 posts - 24,916 through 24,930 (of 26,486 total)