Ok, the problem is back this morning. CPU usage is at about 5-10%. System idle processes is at around 97%.

I've actually had systems with problems where 'reseating all the ram and PCI cards' have turned it into a stable system. Suprised that it took that long for someone...

I have indexes on 99.9% of my tables. I just don't have a PK on any of them. I can't control the data from my sources.

Here's...

As I said originally hard drives were failing.

It had been about a month since a reboot.

I didn't look at kernel stats before the reboot, but I will next time it...

I have used the Index Tuning wizard on many occasions. All it all, it's not a lot of help to me. It mostly just gives me a warm...

If my system is purely reporting, why would I want to have an identity field as a PK? I just add rows to the table daily and never remove...

I know this will shock a lot of people, I pull about 90% of my data from other sources and don't ever use PK.

I can't guarantee that all...

System shows 97% System Idle Processes.

I am generating a new file everytime.

Disk array is a 1TB RAID 5 drive spread across 2 drives in Windows

Don't know why, but we...

The -b did what I wanted. That was the first that I tried. I even tried to put a couple of 'go's in the script and it stopped...

ALZDBA - Thanks a lot, I will test that out. Sorry if I seemed irritated by your original post. I was thinking that you were one of those...

Why would ARITHABORT ON have ANYTHING to do with my problem with returning an error condition from an isql script? I said nothing in my original post about divide...

I don't remember where I got this from, but I this may help you out.

SELECTcntr_value, counter_name

FROMmaster..sysperfinfo PageSplitsSec (nolock)

WHERE (object_name = 'SQLServer:Memory Manager'

AND counter_name = 'Total Server Memory...

Who is your email provider that you have registered with this site? I wasn't getting emails and then I registered my hotmail account instead and now I get all...

I think that the brackets are a pain in the butt that just bandaids poor naming conventions. Why would you name a column SELECT or any reserved words? ...

Also, be sure to consider how the data gets populated. I'm lucky in the fact that most of my tables are inserted into daily and I have a char(10)...