paradox (pair o' docs)

We've disabled TCP Offloading on the SQL Server systems. Now it is a waiting game to see if the intermittent problem still occurs.

GilaMonster (3/5/2010)

---

Here you go

http://support.microsoft.com/kb/324270

On Server 2003 RTM, the setting for SynAttackProtect is 0. With SP1 it was changed to 1.

iirc, that's the one that we had to change back...

I find using google and the Microsoft Knowledge Base quite the same. It is an art to find what you are looking for quickly.

I'd spend hours looking in the...

Probably leaves me out, but not sure where HB is.

GilaMonster (3/5/2010)

---

Had same thing some time back. Turned out to be a side-effect of the anti-DoS features added in, i think, a service pack of Win server 2003. Details fail...

Data caching. The first time you run the query the data has to be pulled from disk. Subsequent queries for the same data pull from cache.

I'd be curious as well. Also, is this something that could be done remotely?

Fatal Exception Error (3/5/2010)

---

Chad Crawford (3/5/2010)

---

If it's the points you need - there are about a half dozen different ways to guarantee you get the QOD right every time,...

Jack,

Thanks. I have forwarded the info you provided to my PeopleSoft Admin and Network Services. We'll see what transpires and I'll keep everyone posted.

As to the second blog,...

You need to cast 1.8 as a float. See the following:

create table #temp (

column1 float

);

declare @TestVar float;

set @TestVar = 975.81;

insert into #temp select @TestVar;

select column1

...

Okay denizens, looking for ideas and suggestions here.

Thanks.

Toreador (3/5/2010)

---

bitbucket-25253 (3/5/2010)

---

May I point out that the SSC community includes members from countries...

I'll give you one right now as i have already seen it posted in other threads: Wait a day, the next days email newsletter contains the answer to the...

You also need to be sure to GRANT CONNECT permissions to the endpoints for the service account that SQL Server is running under. Ran into that issue when trying...